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.

Showing Answers 1 - 2 of 2 Answers

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.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions