Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
- 5 Answers
- 11577 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 trigger and how to use it in sql?
What is the purpose of using pl/sql?
What are some predefined exceptions in pl/sql?
What is oracle sql called?
How many rows can sqlite handle?
How would you reference column values before and after you have inserted and deleted triggers?
What type of join is sql join?
What is clustered and nonclustered index in sql?
what is sql profiler? : Sql dba
How do you sort in sql?
How do I start sql from command line?
What are the features of pl sql?
Can we use two order by clause in query?
What is difference between procedure and trigger?
Which operator is used in query for pattern matching?
