SQL (Structured Query Language) Question:
What is SQL Mutating Table?
Answer:
Mutating Table is a table that is currently being modified by an Insert, Update or Delete statement. Constraining Table is a table that a triggering statement might need to read either directly for a SQL statement or indirectly for a declarative Referential Integrity constraints. Pseudo Columns behaves like a column in a table but are not actually stored in the table. E.g. Currval, Nextval, Rowid, Rownum, Level etc.
Previous Question | Next Question |
What is SQL Rollback? | Operators used in SELECT statements. |