DEVFYI - Developer Resource - FYI

What are two virtual tables available during database trigger execution ?

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

469. What are two virtual tables available during database trigger execution ?

The table columns are referred as OLD.column_name and NEW.column_name.
For triggers related to INSERT only NEW.column_name values only available.
For triggers related to UPDATE only OLD.column_name NEW.column_name values only available.
For triggers related to DELETE only OLD.column_name values only available.

(Continued on next question...)

Other Interview Questions