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'

 

转载于:https://www.cnblogs.com/sstone/p/6525529.html