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 table?

Answer Posted / pavan_1981

A mutating table is a table that is currently being
modified by an update, delete, or insert statement. For
example, if your trigger contains a select statement or an
update statement referencing the table it is triggering off
of you will receive the error.
Another way this error can occur is if the trigger has
statements to change the primary, foreign or unique key
columns of the table the trigger is triggering off of.

Is This Answer Correct ?    124 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you write a complex sql query?

1007


What is denormalization in a database?

994


what is meant by nl2br()? : Sql dba

974


What is hibernate and its relation to sql?

1066


How do you concatenate in sql?

973


What is the use of triggers?

979


How to revise and re-run the last sql command?

1099


What is Difference Between Unique and Primary Key Constraints?

1058


What is a heap in sql?

992


How does postgresql compare to "nosql"?

981


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1040


What is trigger in flip flop?

958


Which join condition can be specified using on clause?

899


Why do you partition data?

965


How do I start sql profiler?

941