What Is Mutating Table

Q

What Is Mutating Table?

✍: fyicenter.com

A

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.

2007-04-15, 4963👍, 0💬