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...

What is mutating trigger?How to avoid it??

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many functions are there in sql?

1024


What type of join is sql join?

982


what are the authentication modes in sql server? : Sql dba

1063


what happens if you no create privilege in a database? : Sql dba

1001


How is a process of pl/sql compiled?

1160


How do you write a subquery?

1026


Explain the difference between rename and alias?

1010


What is sqlcommand?

1030


What is data type in database?

992


Can we create foreign key without primary key?

985


How do I write a cron which will run a sql query and mail the results to agroup?

981


Why sql query is slow?

997


What is cte?

982


What are the topics in pl sql?

971


What is rownum?

980