Interested to Buy Any Domain ? << Click Here >> for more details...
What is mutating trigger?How to avoid it??
- 3 Answers
- 13869 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
Is sqlite free?
Is hadoop a nosql?
What is coalesce in sql?
What kind of join is join?
How many sql core licenses do I need?
what is 'mysqlimport'? : Sql dba
What is difference between nchar and nvarchar?
What is the difference between the conventional and direct path loader? : aql loader
Write a query to display the current date in sql?
what is timestamp in mysql? : Sql dba
What is a sql driver?
Compare sql & pl/sql
How many sql commands are there?
What is mdb stand for?
how to run 'mysql' commands from a batch file? : Sql dba
