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
- 17288 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 show all tables with 'mysql'? : Sql dba
What is recursive join in sql?
Explain the working of primary key?
Explian rowid, rownum? What are the psoducolumns we have?
What is partition in sql query?
What is the usage of distinct keyword?
How do you identify a primary key?
What is the use of & in pl sql?
how to see the create table statement of an existing table? : Sql dba
What is multiple columns?
how to select unique records from a table? : Sql dba
What are different types of functions in sql?
What is the difference between having clause and where clause?
How to check if a column is nullable before setting to nullable?
What is the difference between subquery and correlated query?
