这样呢?CREATE OR REPLACE PROCEDURE TEST IS
ls_str varchar2(100);
i number(2);
ls_je number(10);
BEGIN
i:=1 ;
ls_je:=123;
ls_str:='update tb_hbdg set Z00'||i||'='||ls_je||';';
EXECUTE IMMEDIATE ls_str ;
END TEST;
ls_str varchar2(100);
i number(2);
ls_je number(10);
BEGIN
i:=1 ;
ls_je:=123;
ls_str:='update tb_hbdg set Z00'||i||'='||ls_je||';';
EXECUTE IMMEDIATE ls_str ;
END TEST;
EXECUTE IMMEDIATE ls_str USING ls_je;
IS
ls_str varchar2(100);
i number(2);
ls_je number(10);
BEGIN
i:=1 ;
ls_je:=123;
ls_str:='update tb_hbdg set Z00'''||i||''' = '||ls_je;
EXECUTE IMMEDIATE ls_str ;
END TEST;