Oracle PL-SQL Question:

What are two virtual tables available during database trigger execution?

Answer:

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.

Download Oracle PL-SQL PDF Read All 52 Oracle PL-SQL Questions

Previous Question	Next Question
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger? Why?	What happens if a procedure that updates a column of table X is called in a database trigger of the same table?