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
What is the best free sql database?
Explain commit, rollback and savepoint.
Is left join inner or outer?
What is difference between left and right outer join?
What is relationship? How many types of relationship are there?
what are all different types of collation sensitivity? : Sql dba
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is the starting oracle error number? What is meant by forward declaration in functions?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
How to move files from one directory to another in pl sql?
What is execution plan in sql?
What is the use of sqldataadapter?
What is fmtonly in sql?
How many triggers can be applied to a table?
Which are sql * plus commands?
