Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?
- 5 Answers
- 15988 Views
- I also Faced
- E-Mail Answers
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
How to avoid duplicate records in a query?
What are the set operators in sql?
Does sql support programming?
Is sql a backend?
What is rowtype?
What is the difference between the implicit and explicit cursors?
What is nested table in pl sql?
Do prepared statements prevent sql injection?
What is the command used to fetch the first 5 characters of a string?
How to take user input in pl sql?
What are variables in pl sql?
What is sqlerrd?
What is basic structure of pl sql?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
