Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kaushik
A mutating table is a table that is currently being modified
by an UPDATE, INSERT or DELETE statement, or a table that
might need to be updated by the effects of a declarative
DELETE CASCADE referential integrity action. A table is not
considered mutating for STATEMENT triggers.
The triggered table itself is a mutating table as well as
any table referencing it with the foreign key constraint.
This restriction prevents a row trigger from seeing an
inconsistent set of data.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Which nosql database is best?
What is cursor in pl sql?
How do you use a while loop in pl sql?
What is a scalar value in sql?
What is a table in a database?
Does sql between include endpoints?
Name the operator which is used in the query for pattern matching?
What are the advantages of stored procedure?
Can I join the same table twice?
What is error ora-01000: maximum open cursors exceeded
How do I run a script in sql developer?
What are properties of the transaction?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How does pl sql work?
How do I audit the sql sent to the server?
