无语,上代码:
create or replace function IS_NUMBER(string VARCHAR2) return integer is
begin
if(LENGTH(TRIM(TRANSLATE(string, ' +-.0123456789', ' '))) is null ) then
return 1;
else
return 0;
end if;
end IS_NUMBER;
无语,上代码:
create or replace function IS_NUMBER(string VARCHAR2) return integer is
begin
if(LENGTH(TRIM(TRANSLATE(string, ' +-.0123456789', ' '))) is null ) then
return 1;
else
return 0;
end if;
end IS_NUMBER;