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.
  • Interview Candidate
  • 6
  • 14476

Showing Answers 1 - 6 of 6 Answers

krishnaindia2007

  • May 6th, 2008
 

OLD and NEW are two virtual tables available during database trigger execution.

UPDATE statement has access to  both old and new values.

INSERT  statement has access only to new values. Old values are NULL for insert statement.

DELETE satement has access only to old values.  New values are NULL for delete statement.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions