Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?
Answer Posted / tulsi
It is not possible. As triggers are defined for each table,
if you use COMMIT of ROLLBACK in a trigger, it affects
logical transaction processing.
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
What language is oracle sql developer?
Why commit is not used in triggers?
What is int identity in sql?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
How do I add a primary key to a table?
What is full form of rtm?
Which function is used to return remainder in a division operator in sql?
What is primary key and unique key?
What is the most common sql injection tool?
Which is better stored procedure or query?
What is bitemporal narrowing?
What has stored procedures in sql and how we can use it?
What are basic techniques of indexing?
Which constraints we can use while creating database in sql?
What are secondary keys?