declare a varchar2(100); b number; var_sql varchar2(100); begin a:='2+123-5*4/5'; var_sql:=' select '|| a|| ' from dual'; dbms_output.put_line(to_char(var_sql)); execute immediate var_sql into b ; dbms_output.put_line(to_char(b)); end;
lz你的动态selects的语法不对execute immediate <dyn_string> into 变量 using 绑定变量;
a varchar2(100);
b number;
var_sql varchar2(100);
begin
a:='2+123-5*4/5';
var_sql:=' select '|| a|| ' from dual';
dbms_output.put_line(to_char(var_sql));
execute immediate var_sql into b ;
dbms_output.put_line(to_char(b));
end;
using 绑定变量;