Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
- 5 Answers
- 13638 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / nitinsharma06
Yes we can, the trigger will get compile also if you use commit inside it and that is without using PRAGMA AUTONOUMS TRANSACTION, but when you execute the DML operation it fails to execute.
So in compilation you won't get any error and while execute trigger will throw error.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is #table in sql?
Does mysql support pl sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
Does db2 use sql?
What is self-join and what is the requirement of self-join?
How to find 3rd highest salary of an employee from the employee table in sql?
What is the need of merge statement?
What are character functions?
What are operators available in sql?
Explain two easy sql optimizations.
What is a unique key and primary key and foreign key?
Why join is faster than subquery?
What is string join?
what is error ora-03113: end-of-file on communication channel?
What is the difference between inner join and natural join?
