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
- 13413 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 interval partition?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
Can we use two order by clause in query?
Is sql workbench free?
Explain the types of joins in sql?
Why do we need databases?
What is sql query limit?
what is the difference between cluster and non cluster index? : Sql dba
what is the use of friend function? : Sql dba
What is difference between nchar and nvarchar?
What are the types of views in sql?
Is left join faster than inner join?
What are the disadvantages of file system?
How to move files from one directory to another in pl sql?
Can there be more than one function with a similar name in a pl/sql block?
