触发器如下:create or replace trigger zlsq_st
after update on r5objects
for each row
declare
d_rkh r5orders.ord_udfchar01%type;
begin
select f.ord_udfchar01 into d_rkh
from r5orders f, r5objects e
where f.ord_code = e.obj_order
and f.ord_status = 'JLPZ'and :old.obj_code=:new.obj_code; if :new.obj_status='I' then
update r5requisitions
set REQ_UDFCHAR01 = '已发放'
where req_code=d_rkh;
end if;
END zlsq_st;
我更想r5objects表中obj_status字段时候出现
Oracleselect
after update on r5objects
for each row
declare
d_rkh r5orders.ord_udfchar01%type;
begin
select f.ord_udfchar01 into d_rkh
from r5orders f, r5objects e
where f.ord_code = e.obj_order
and f.ord_status = 'JLPZ'and :old.obj_code=:new.obj_code; if :new.obj_status='I' then
update r5requisitions
set REQ_UDFCHAR01 = '已发放'
where req_code=d_rkh;
end if;
END zlsq_st;
我更想r5objects表中obj_status字段时候出现
Oracleselect
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货