What is the difference between a mutating table and a constraining tab – InterviewSolution

InterviewSolution

1.	What is the difference between a mutating table and a constraining table?
Answer» A table that is being MODIFIED by the usage of the DML STATEMENT currently is KNOWN as a mutating table. It can also be a table that has triggers defined on it. A table used for reading for the purpose of referential INTEGRITY CONSTRAINT is called a constraining table.

Discussion

No Comment Found

Related InterviewSolutions

Is it possible to declare column which has the number data type and its scale larger than the precision? For example defining columns like: column name NUMBER (10,100), column name NUMBER (10,-84)
In what cursor attributes the outcomes of DML statement execution are saved?
What is the difference between a mutating table and a constraining table?
How can you debug your PL/SQL code?
What are COMMIT, ROLLBACK and SAVEPOINT statements in PL/SQL?