Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?
Answer Posted / deva
yes we cannot make TCL commands with in triggers. If the
block is declared as a autonomous transaction, then commit
and rollback can be given in the end of the block
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is data control language (dcl)?
What is the difference between a database and a relational database?
What are the advantages of sql? Explain
How would you convert date into julian date format?
Write a unique difference between a function and a stored procedure.
What is the best free sql database?
How can you view the errors encountered in a trigger?
What are triggers in sql?
Explain what is dbms?
What can sql server reporting services do?
What is a sql profiler?
What is a trigger in sql?
What is the purpose of normalization?
what is the bond code in materialized view?
What is sql trigger example?