Answers

Question and Answer:

  Home  Oracle PL-SQL

⟩ 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.

 199 views

More Questions for you: