create or replace function get_number(str varchar2)
return varchar2 is
v_rs varchar2(4000);
begin
if str is null then
return null;
else
for i IN 1 .. length(str) loop
if ascii(substr(str, i, 1)) between 48 and 57 then
v_rs := v_rs || substr(str, i, 1);
end if;
end loop;
return v_rs;
end if;
end;
return varchar2 is
v_rs varchar2(4000);
begin
if str is null then
return null;
else
for i IN 1 .. length(str) loop
if ascii(substr(str, i, 1)) between 48 and 57 then
v_rs := v_rs || substr(str, i, 1);
end if;
end loop;
return v_rs;
end if;
end;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8382469/viewspace-259866/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8382469/viewspace-259866/