Oracle触发器学习

create or replace trigger pro_trigger after insert on product
begin
      dbms_output.put_line('欢迎新商品!');
end;

  
insert into product(uuid,code,name) values('4','10003','测试') 
create or replace trigger pro_trigger1 after delete on product 
for each row
begin 
       dbms_output.put_line(:old.name||'已被删除!');
end;

delete from product where uuid = '4'

 

posted on 2017-03-09 14:29  花溪的小石头  阅读(130)  评论(0编辑  收藏  举报