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
Is it possible to create startup or shutdown trigger for on-schema?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What are the set operators in sql?
How to display Row Number with Records in Oracle SQL Plus?
How to use boolean type in select statement?
How to convert comma separated string to array in pl/sql?
What are sql triggers used for?
What is constant in pl sql?
What is the usage of distinct keyword?
Explain the advantages and disadvantages of stored procedure?
What is full join?
What are the two types of exceptions.
How to add a column ‘salary’ to a table employee_details?
how is exception handling handled in mysql? : Sql dba
What is serial sql?