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
- 17126 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
How can we make an if statement within a select statement?
What is the size of partition table?
Why sql query is slow?
What is rownum and rowid?
What are the steps for performance tuning.
What is difference between function and trigger?
What are the advantages of indexing?
What is union?
Can we call dml statement in function?
what is a join? : Sql dba
How can I tell if sql is running?
how to include comments in sql statements? : Sql dba
How can you load microsoft excel data into oracle? : aql loader
What is the usage of nvl function?
Explain ddl statements in pl/sql?
