Interested to Buy Any Domain ? << Click Here >> for more details...
What is mutating trigger?How to avoid it??
- 3 Answers
- 13929 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / megha bidve
Use autonomous transactions because is it we can use commit
inside the trigger.
Autonomous transactions allow you to leave the context of
the calling transaction, perform an independant
transaction, and return to the calling transaction without
affecting it's state. The autonomous transaction has no
link to the calling transaction, so only commited data can
be shared by both transactions.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what is auto increment? : Sql dba
Why is %isopen always false for an implicit cursor?
What are the basic techniques of indexing?
How many sql statements are used? Define them.
What is the difference between having and a where in sql?
What is thread join () in threading?
What is server name sql?
Define tables and fields in a database
How to write pl sql program in mysql command prompt?
What is delete command in sql?
Is subquery faster than join?
What are triggers in sql?
What are the two characteristics of a primary key?
Is progress software supports to ( pl/sql )?
How to run sql statements with oracle sql developer?
