AiM

• Aug 23rd, 2014

 

Trigger code to create a trigger in disable mode starting 11g

Code
create or replace trigger prac_trig_emp1


before insert or update OR DELETE


ON emp1


REFERENCING NEW AS NEW OLD AS OLD


FOR EACH ROW DISABLE


BEGIN


IF INSERTING THEN


INSERT INTO emp1_aud (a) VALUES (Insert)


ELSIF DELETING THEN


INSERT INTO emp1_aud (a) VALUES (Delete)


ELSIF UPDATING THEN


INSERT INTO emp1_aud (a) VALUES (Update)


END IF


END prac_trig_emp1


 


 


ALTER TRIGGER prac_trig_emp1 enable


ALTER TRIGGER prac_trig_emp1 disable