Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
- 5 Answers
- 12401 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 the use of index in hive?
how is myisam table stored? : Sql dba
what are the security recommendations while using mysql? : Sql dba
what are the types of join and explain each? : Sql dba
what is a trigger in mysql? Define different types of trigger. : Sql dba
what are the disadvantages of mysql? : Sql dba
Why left join is used in sql?
Is sql port 1433 encrypted?
What does pl sql developer do?
Is pl sql and postgresql same?
How can I tell if sql is running?
what are date and time functions in mysql? : Sql dba
What are the parts of a sql statement?
How to run sql*plus commands in sql developer?
What is oracle pl sql developer?
