Interested to Buy Any Domain ? << Click Here >> for more details...
Can i use Commit inside the Trigger? Suppose i use commit
what will be happy (it's complied /executed/work)
- 6 Answers
- 15005 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
commit,rollback and savepoint cannot be used in a trigger
directly, but it can be called in a stored procedure
present in the trigger. however it is usually avoided as it
might have sideeffects in transactions.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Does google use sql?
How do I clear the screen in sql plus?
How many columns should be in an index?
How show all rows in sql?
Explain what is a database?
Mention what does the hierarchical profiler does?
Where can I learn sql for free?
Can we use update in sql function?
how to start mysql server? : Sql dba
How can you get sql*loader to commit only at the end of the load file? : aql loader
How do you optimize a stored procedure query?
How to use distinct and count in sql query? Explain
Explain 3 basic parts of a trigger.
Why do we use %rowtype & %type in plsql?
What is sql injection vulnerability?
