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
- 17082 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
how to run 'mysql' commands from a batch file? : Sql dba
What is difference between ms sql and mysql?
What is difference between inner join and self join?
Can a select statement fire a trigger?
How do I clear the screen in sql plus?
what are the limitations of identity column? : Transact sql
how to use 'mysql' to run sql statements? : Sql dba
What are the two different parts of the pl/sql packages?
How much does sql certification cost?
Name the operator which is used in the query for pattern matching?
Explain scalar functions in sql?
Can we use loop in sql?
Define commit, rollback and savepoint?
How do you explain an index?
how to write date and time literals? : Sql dba
