创建触发器SYS @ prod > CREATE OR REPLACE TRIGGER drop_trigger BEFORE DROP ON hr.SCHEMA BEGIN RAISE_APPLICATION_ERROR ( num => -20000, msg => 'Cannot drop object'); END;Trigger created.根据创建触发器时指定的 TABLE_OWNER 为 HR，查找刚才创建的触发器SYS @ prod > select owner,trigger_name,table_owner from dba_triggers where table_owner='HR';OWNER TRIGGER_NAME TABLE_OWNE----- -------------------- ----------HR SECURE_EMPLOYEES HRHR UPDATE_JOB_HISTORY HRSYS DROP_TRIGGER HR根据 触发器名称、触发器所属用户查找该触发器的编写代码SYS @ prod > select dbms_metadata.get_ddl('TRIGGER','DROP_TRIGGER','SYS') from dual;DBMS_METADATA.GET_DDL('TRIGGER','DROP_TRIGGER','SYS')-------------------------------------------------------------------------------- CREATE OR REPLACE TRIGGER "SYS"."DROP_TRIGGER" BEFORE DROP ON hr.SCHEMA
转载于:https://www.cnblogs.com/iyoume2008/p/4690663.html
相关资源：很好的触发器代码@@@@@@@