服务热线:13616026886

技术文档 欢迎使用技术文档,我们为你提供从新手到专业开发者的所有资源,你也可以通过它日益精进

位置:首页 > 技术文档 > 数据库技术 > Oracle技术 > Oracle开发 > 查看文档

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

【赛迪网-it技术报道】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;

扫描关注微信公众号