实现四则运算的一条sql语句

czhtony · 发表于 2008-10-29 09:23

水平高

fireguok · 发表于 2008-11-1 13:28

I tried a few times and seems not working all the time.

yanfei082927 · 发表于 2008-11-3 10:12

我用的也是9i,没有regexp_replace啊,该怎么转换呢

sfgvvv__ · 发表于 2008-11-4 15:19

我是这样做的：
function charToNumber(p_char varchar2)return number
  is
  lv_sql varchar2(500);
  lv_num number;
  begin
lv_sql:='select '||p_char||' from dual';
execute immediate lv_sql into lv_num;
   return(lv_num);
  exception when others then
  --dbms_output.put_line('error!');
return(0);
  end charToNumber;