|
1>函数转换
select nvl2(translate(a.data, '\1234567890.', '\'), null, a.data) n, a.data from rpt_detail a;
2>自定义函数
create or replace function isNumber(p_in varchar2) return boolean as
i number;
begin
i:=to_number(p_in);
return true;
exception
when others then
return false;
end ;
|
|