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
- 14800 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
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
Can we use joins in subquery?
How do you rank data in sql?
Do foreign keys improve performance?
What is where clause in sql?
What is mutating error in pl sql?
what is a join? : Sql dba
Is nosql faster than sql?
what are all different types of collation sensitivity? : Sql dba
what is the difference between where clause and having clause? : Sql dba
What is left join example?
Why we use sql profiler?
What is the best free sql database?
What are the dml statements?
What is the maximum number of rows in sql table?
