实例讲解Oracle数据库自带的几个触发器

王朝oracle·作者佚名  2008-06-01
窄屏简体版  字體: |||超大  

Oracle数据库自带的几个触发器(最简单触发器格式)

示例如下:

--

create or replace trigger MDSYS.sdo_drop_user

after drop on DATABASE

declare

stmt varchar2(200);

BEGIN

if dictionary_obj_type = 'USER' THEN

stmt := 'DELETE FROM SDO_GEOM_METADATA_TABLE ' ||

' WHERE SDO_OWNER = ''' || dictionary_obj_name || ''' ';

EXECUTE IMMEDIATE stmt;

end if;

end;

---

create or replace trigger SYS.aurora$server$startup after startup on database

call dbms_java.server_startup

--

create or replace trigger SYS.JIS$ROLE_TRIGGER$ after drop on database

when (ora_dict_obj_type='ROLE')

begin

sns_context.role_dropped(ora_dict_obj_name);

http_security_cascade.principal_dropped(ora_dict_obj_name);

end;

--删除前备份数据的器

Create Or Replace Trigger YSPJ.T_Bill_reMain_Del

Before delete On bill_remain

FOR EACH ROW

begin

Insert into BILL_REMAIN_TIGER

Values(:old.BILL_REMAINID,:old.BILL_TYPEID,:old.REMAIN_NUM,:old.ADD_TIME,:old.ORG_ID,

:old.STATE,:old.BILL_ID,'删除记录',Sysdate,user);

End;

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航