Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?
- 5 Answers
- 15978 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
Why do you partition data?
What types of commands can be executed in sql*plus?
What is t sql used for?
How does sql store data?
Which tcp/ip port does sql server run?
Is it possible to pass parameters to triggers?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What are user defined functions?
What are some predefined exceptions in pl/sql?
How do I audit the sql sent to the server?
How do I create a sql database?
What is natural join in sql?
How can we make an if statement within a select statement?
what is csv? : Sql dba
what are enums used for in mysql? : Sql dba
