create or replace procedure dqzj_dfxx(ac_ny in varchar2,ac_qf in varchar2) is
n_abc number;
str varchar2(200);
begin
str:='insert into n_abc select :1 from qfb1 where ny=:2';
execute immediate str using ac_qf,ac_ny;
end;
n_abc number;
str varchar2(200);
begin
str:='insert into n_abc select :1 from qfb1 where ny=:2';
execute immediate str using ac_qf,ac_ny;
end;
n_abc number;
str varchar2(200);
begin
str:='insert into n_abc select'||ac_ny ||' from qfb1 where ny='||ac_qf ;
execute immediate str;
end;
execute immediate 'update jczj_c_dfxx a set ysdf= (select qf10 from dq.dfsqf b where a.hh=b.hh)' ;
create or replace procedure dqzj_dfxx(
ac_qfny in varchar2
}is
begin
execute immediate 'update jczj_c_dfxx a set ysdf= (select '||ac_qfny||' from dq.dfsqf b where a.hh=b.hh)' ;
end;
declare
ac_qfny varchar2(10):='qf10';
beginupdate jczj_c_dfxx a set ysdf= (select '||ac_qfny||' from dq.dfsqf b where a.hh=b.hh);end;
/
update jczj_c_dfxx a set ysdf= (select '||nvl(ac_qfny,0)||' from dq.dfsqf b where a.hh=b.hh);
declare
ac_qfny varchar2(10):='qf10';
ac_dw varchar2(4):='C1'
begin
execute immediate 'update jczj_c_dfxx a set ysdf= (select '||ac_qfny ||'
from dq.dfsqf b where a.hh=b.hh) where dw='||ac_dw;
end; /