Interested to Buy Any Domain ? << Click Here >> for more details...
Can i use Commit inside the Trigger? Suppose i use commit
what will be happy (it's complied /executed/work)
- 6 Answers
- 14732 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
commit,rollback and savepoint cannot be used in a trigger
directly, but it can be called in a stored procedure
present in the trigger. however it is usually avoided as it
might have sideeffects in transactions.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is rownum in sql?
what is a database transaction? : Sql dba
What operating systems are supported by oracle sql developer?
What is over () in sql?
Why do we use procedures in sql?
What is clause in sql?
what is the use of double ampersand (&&) in sql queries?
what are the drivers in mysql? : Sql dba
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
where are cookies actually stored on the hard disk? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
Is not null in sql?
What is the difference between syntax error and runtime error?
What are secondary keys?
What is multiple partition?
