DML Triggers in PL/SQL


*****************************************************
CREATE OR REPLACE TRIGGER EMPTRG BEFORE UPDATE ON EMP
BEGIN
   DBMS_OUTPUT.PUT_LINE(' Record Updated ');
END;
*****************************************************
CREATE OR REPLACE TRIGGER EMPTRG2
BEFORE UPDATE ON EMP FOR EACH ROW
BEGIN
   DBMS_OUTPUT.PUT_LINE(' RECORD UPDATED ');
END;
*****************************************************
Previous
Next Post »