Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is the benefit of foreign key?
What is the difference between drop and truncate commands?
What are the different dcl commands in sql?
What are the uses of merge?
how many ways to get the current time? : Sql dba
Is pl sql better than sql?
What is the difference between nested table and varray?
What does closing a cursor do?
What is field delimiter?
How to move files from one directory to another in pl sql?
What is the use of non clustered index?
What is partition by in sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is memory optimized?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
