Oracle triggers 6-manage triggers

Oracle trigger 6-manage trigger Oracle trigger 5-Instead of trigger http://www.bkjia.com/database/201304/203344.html 1. disable, enable, and delete trigger alter trigger trigger_name disable; alter trigger trigger_name enable; drop trigger trigger_name; example: disable or enable the create or replace PROCEDURE settrig (tab IN VARCHAR2, sch in varchar default null, action IN VARCHAR2) ISl_action VARCHAR2 (10): = UPPER (action ); l_other_action VARCHAR2 (10): = 'Disabled' ; BEGINIF l_action = 'disable' THENl_other_action: = 'enabled'; end if; FOR rec IN (SELECT trigger_nameFROM user_triggersWHERE table_owner = UPPER (NVL (sch, USER )) AND table_name = tabAND status = l_other_action) loopexecute immediate 'alter trigger' | rec. trigger_name | ''| l_action; end loop; END; 2. create or replace TRIGGER just_testingAFTER insert on abc DISABLEBEGINNULL; END; -- note that re-compilation is disabled Will activate the trigger. 3. Data Dictionary view related to the TRIGGER DBA_TRIGGERSALL_TRIGGERSUSER_TRIGGERS4. Check the validity of the trigger SQL> SELECT object_name, object_type, statusFROM user_objectsWHERE object_name = 'invalid _ TRIGGER ';