Category Archives: Triggers in Oracle

Q1. Explain two virtual tables available at the time of database trigger execution. Answer. :OLD and :NEW are the 2 virtual tables available at the time of database trigger execution. The table columns are referred as :OLD.column_name and :NEW.column_name. Trigger Event Availability of values in :NEW.column_name :OLD.column_name Insert Available Not Available Update Available Available DeleteContinue reading “Triggers”