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