oracle数据库触发器例子

 CREATE OR REPLACE TRIGGER "GRN"."O_STAFF" BEFORE
INSERT ON "SC" FOR EACH ROW declare
vsid char(10);
vsname char(20);
vsp number(1);
vno char(2);
vtemp number(38);
begin
select sid into vsid from sc where sid=:new.sid;
exception
when NO_DATA_FOUND then
begin
 insert into staff (sid,sname,sp,temp)
 values(:new.sid,
 :new.sname,
 :new.sp,
 :new.temp);
 end;
end;