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
- 16871 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 cascade in sql?
What is integrity in sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
How does postgresql compare to oracle/db2/ms sql server/informix?
what is the difference between myisam static and myisam dynamic? : Sql dba
What is a dynamic query?
What is the location of pre_defined_functions.
How to display the current date in sql?
What are types of indexes in sql?
what is a composite key ? : Sql dba
Is sql an operating system?
Name some usages of database trigger?
What is cursor and its types?
What is sql dialect?
Is sql sequential or random?
