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
- 17123 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 create a test table in your mysql server? : Sql dba
what happens if you no create privilege in a database? : Sql dba
Differentiate between syntax and runtime errors.
What is normalisation and its types?
What is t-sql? : Transact sql
What is the reports view in oracle sql developer?
Can we edit a view in sql?
What is acid property in a database?
What are the different dml commands in sql?
What is thread join () in threading?
What is a sql schema used for?
Does truncate need commit?
What are the different parts of a package?
how to drop an existing index in mysql? : Sql dba
Are sql database names case sensitive?
