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
- 17087 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
how to get @@error and @@rowcount at the same time? : Sql dba
How do you explain an index?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Are subqueries faster than joins?
What kind of join is join?
How can I see all tables in sql?
How do I find duplicates in a single column in sql?
What is the size of partition table?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is right join sql?
Is sqlite thread safe?
Can you join views in sql?
What does 0 mean in sql?
how to rename an existing column in a table? : Sql dba
What does pl sql developer do?
