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;
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;