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
How to select all records from the table?
What are stored procedures in mysql?
What is sql and its types?
Can we join 3 tables in sql?
Which join is like inner join?
Explain locks? : Transact sql
What is the limitation on the block size of pl/sql?
what is bdb (berkeleydb)? : Sql dba
what are wild cards used in database for pattern matching ? : Sql dba
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is function and procedure?
What is the difference between inner join and left join?
What are the two types of periodical indexes?
What is foreign key in sql with example?
What is the maximum number of rows in sql table?