create or replace trigger zfcc_1 after insert on commodity for each rowdeclare productor_name varchar2(20);begin
select PRODUCTORNAME into productor_name from factory where PRODUCTORID= :new.PRODUCTORID;
insert into shortinfo(COMMPK,PRODUCTORID,INFORMATION,C_NAME,P_NAME) values ( :new.COMMPK,:new.PRODUCTORID,productor_name||'生产的'||:new.COMMODITYNAME, :new.COMMODITYNAME,productor_name); end zfcc_1;请看这个写的是否正确? 我需要周一到公司去实验
after insert on commodity
for each rowdeclare
productor_name varchar2(20);begin
select PRODUCTORNAME into productor_name from factory where PRODUCTORID= :new.PRODUCTORID;
insert into shortinfo(COMMPK,PRODUCTORID,INFORMATION,C_NAME,P_NAME) values ( :new.COMMPK,:new.PRODUCTORID,productor_name||'生产的'||:new.COMMODITYNAME, :new.COMMODITYNAME,productor_name); end zfcc_1;请看这个写的是否正确? 我需要周一到公司去实验