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
- 16843 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
Can we use two order by clause in query?
How do I filter in sql profiler?
Can we write dml inside a function in sql server?
what are sequences
What is sql keyword?
Is like operator in sql case sensitive?
What is normalization in a database?
What is use of term?
How many types of keys are there in sql?
difference between anonymous blocks and sub-programs.
What are schema-level triggers?
Can we join 3 tables in sql?
What is acid property in a database?
What is rowid in sql?
Is drop table faster than truncate?
