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
- 17304 Views
- I also Faced
- E-Mail Answers
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 the difference between inner join and natural join?
What is indexing in sql and its types?
What is trigger types in sql?
What is the difference between syntax error and runtime error?
What is an inconsistent dependency?
What is the use of nvl function?
What is rownum?
What is the difference between partition and index?
What are the different types of joins in sql?
how to load data files into tables with 'mysqlimport'? : Sql dba
What is difference between joins and union?
what is the difference between nested subquery and correlated subquery?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is procedure in pl sql?
What are the limitations of sql express?
