谢谢lianhg,不过觉得那样也太。。。了
刚刚写了一个函数,这样就省事多了,结帐了
create or replace function PARSE_NUMBER
(VAR_VALUE IN VARCHAR)
return NUMBER is
Result NUMBER;
begin
Result := TO_NUMBER(VAR_VALUE);
return Result;
EXCEPTION WHEN others THEN
begin
return 0;
end;
end PARSE_NUMBER;
=======================================================================
SQL> SELECT TO_NUMBER(decode(decode(lower(sal),upper(sal),1,0),1,sal,0)) FROM my
emp;