Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?
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
What is sql indexing?
Explain the insert into statements in sql?
What is a primary key? Explain
What is varchar used for?
Explain the rollback statement?
What is sql*loader and what is it used for?
what is the difference between clustered and non clustered index in sql? : Sql dba
What is case function?
What are string functions in sql?
Where can I learn sql for free?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
how many columns can be used for creating index? : Sql dba
Is sql free?
Does group by remove duplicates?
What is a data definition language?