Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?
- 5 Answers
- 17088 Views
- I also Faced
- E-Mail Answers
Answer Posted / aravinda
We can't write COMMIT or ROLLBACK in triggers, because the
triggering event may commit or may not. trigger commit or
rollback is based on triggering event.
even we can't call a subprogram in a trigger which is having
commit or rollback.
but we can achieve through pragma autonomous transaction.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are aggregate functions in sql?
What are the methods of filing?
Does access use sql?
What is sql deadlock?
How do I install sql?
How does postgresql compare to "nosql"?
What is the limitation on the block size of pl/sql?
Can ddl statements be used in pl/sql?
what is the difference between char and varchar data types? : Sql dba
What is difference between group by and partition by?
What is clustered index sql?
Can I join the same table twice?
Why query optimization is needed?
What are the different types of database management systems?
What is the execution plan in sql?
