--触发器
--语言触发器
create or replace trigger tr_pro
before insert--执行插入前操作
on product
begin
if user!='ADMIN' then
--dbms_output.put_line('权限不够');
raise_application_error(-20001,'权限不足');
end if;
end;
--行触发器
--找到最大id新增
create or replace trigger tri_pro_insert
before insert
on product
referencing new as new_value
for each row
when(old.price>5000)--触发器的条件限制
begin
declare max_value number;
begin
select max(ID) into max_value from product;
:new_value.ID:=max_value+1;
end;
end;