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
- 16852 Views
- I also Faced
- E-Mail Answers
Answer Posted / nishi
We can't write COMMIT or ROLLBACK in triggers, because the triggering event may commit or may not. trigger commit or rollback is based on triggering event.
even we can't call a subprogram in a trigger which is having commit or rollback.
but we can achieve through pragma autonomous transaction.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between between and in condition operators?
What are the different types of triggers?
What is the difference between delete and truncate statement in sql?
What is sql key?
What are sql built in functions?
What is crud stand for?
What is minus?
How does cross join work?
what is the difference between undefined value and null value? : Sql dba
what are the different type of normalization? : Sql dba
What is the difference between the conventional and direct path loader? : aql loader
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What is index example?
what is top in tsql? : Transact sql
Can we use rowid as primary key?
