Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is mutating trigger?How to avoid it??

Question Posted / amit bhagat

Answers were Sorted based on User's Feedback



What is mutating trigger?How to avoid it??..

Answer / surendra reddy

Mutaing error happens with triggers. It occurs because the
trigger is trying to update a row it is currently using.
The usual fix involves either use of views or temporary
tables so the database is selecting from one while updating
the other.

Is This Answer Correct ?    13 Yes 4 No

What is mutating trigger?How to avoid it??..

Answer / muthukumar

In trigger when selection and insertion or updation in same
table that time the MUTATING TRIGGER occurs.
U CAN AVOID THAT PROBLEM USE Autonomous transactions .

Is This Answer Correct ?    7 Yes 2 No

What is mutating trigger?How to avoid it??..

Answer / 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

More SQL PLSQL Interview Questions

what is switch column,colums cost in oracle?

0 Answers   Metric Stream,

How can we avoid duplicating records in a query?

0 Answers  

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

What is the maximum number of rows in sql table?

0 Answers  

What is the difference between sql, mysql and sql server?

0 Answers  

What is a sql profiler?

0 Answers  

what is foreign key? : Sql dba

0 Answers  

Why is pl sql used?

0 Answers  

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

How do I start pl sql?

0 Answers  

What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,

how to insert the records in particular position

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories