dingjun123 发表于 2012-9-26 11:49
动态SQL,或者
SQL> select dbms_aw.eval_number('1*1*1*1*.5*.124067*3.3') from dual
2/
好像不能执行,我自己写了个简单的函数给实现了;create or replace function sumbystr(var in varchar2) return number is
Result number;
v string(2000);
begin
v := 'select '||var||' from dual';
execute immediate v into Result;
return(Result);
end sumbystr;复制代码