Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
- 5 Answers
- 11988 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
Can we have two clustered index on a table?
What is pl sql and why it is used for?
Can instead of triggers be used to fire once for each statement on a view?
Is oracle and sql same?
What is rename command in sql?
How many developers work on postgresql?
Explain some predefined exceptions.
Explain the purpose of %type and %rowtype data types with the example?
how to increment dates by 1 in mysql? : Sql dba
What is sp_helptext?
What is the difference between pl and sql?
What is record in pl sql?
How do I delete a trigger?
what is a join? : Sql dba
What is write ahead logging in sql server?
