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
- 16830 Views
- I also Faced
- E-Mail Answers
Answer Posted / nishi
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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we use delete in merge statement?
What is the default isolation level in sql server? : Transact sql
What is sql profiler in oracle?
How does join work in sql?
What is pl/sql table? Why it is used?
How to place comments in pl/sql?
what are the type of locks ? : Sql dba
Explain about various levels of constraint.
What is mutating sql table?
What is the most common sql injection tool?
What is the difference between numeric and autonumber?
What are triggers in sql?
Explain isolation levels. : Transact sql
How do I order columns in sql?
Can we rollback delete command?
