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
- 17295 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 is nvarchar max in sql?
What does the argument [or replace] do?
Why we use sql profiler?
What is dml with example?
What packages are available to pl/sql developers?
Describe sql comments?
what are the properties and different types of sub-queries? : Sql dba
how many columns can be used for creating index? : Sql dba
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
Can we use commit inside a trigger?
what are myisam tables? : Sql dba
What is trigger explain with example?
Can a table contain multiple foreign key’s?
explain advantages of myisam over innodb? : Sql dba
What is a temporal table?
