Oracle PL-SQL Question:

Download Job Interview Questions and Answers PDF

What are two virtual tables available during database trigger execution?

Oracle PL-SQL Interview Question
Oracle PL-SQL Interview Question

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 Interview Questions And Answers PDF

Previous QuestionNext 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?