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
- 16878 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
Is full outer join same as cross join?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is example of database?
How many types of functions are there in sql?
What is dense_rank?
How to convert comma separated string to array in pl/sql?
What are instead of triggers?
How many sql statements are used?
how to increment dates by 1 in mysql? : Sql dba
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is offset in sql query?
what is the difference between group by and order by in sql? : Sql dba
Why we use stored procedure instead of query?
What is pl sql in oracle?
Is sql better than excel?
