What is mutating trigger?How to avoid it??
- 3 Answers
- 13005 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 left join faster than inner join?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is offset in sql query?
What does <> sql mean?
Are sql database names case sensitive?
How do I run a script in sql developer?
What makes a good primary key?
Why functions are used in sql?
What is dbo in sql?
What are all the different normalizations?
What is a left inner join?
what are myisam tables? : Sql dba
What is difference between db2 and sql?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
what are dynamic queries in t-sql? : Transact sql
