支持!--判断数字函数 改进写法create or replace function f_isnumber(str varchar2)
return boolean is
v_num number;
begin if trim(str) is null then
return false;
end if;
v_num:=to_number(str);
return true; exception when others then
return false;
end f_str_or_num;
/
return boolean is
v_num number;
begin if trim(str) is null then
return false;
end if;
v_num:=to_number(str);
return true; exception when others then
return false;
end f_str_or_num;
/
return boolean is
v_num number;
begin if trim(str) is null or instr(str,'.')>0 then
return false;
end if;
v_num:=to_number(str);
return true; exception when others then
return false;
end f_str_or_num;
/
return boolean is
v_num number;
begin if trim(str) is null or instr(str,'.')>0 or instr(str,'-')>0 or or instr(str,'+')>0 then
return false;
end if;
v_num:=to_number(str);
return true; exception when others then
return false;
end f_isnumber;
/
return boolean is
v_num number;
begin if trim(str) is null or instr(str,'.')>0 or instr(str,'-')>0 or instr(str,'+')>0 then
return false;
end if;
v_num:=to_number(str);
return true; exception when others then
return false;
end f_isnumber;
/