create function is_num(p_f002 in varchar2)
return number
as
a number;
begin
a:=to_number(p_f002);
return 1;
exception
when others then
return 0;
end;
/select * from emp where is_num(p_f002)=1;还没正式测试,楼主试用吧
return number
as
a number;
begin
a:=to_number(p_f002);
return 1;
exception
when others then
return 0;
end;
/select * from emp where is_num(p_f002)=1;还没正式测试,楼主试用吧
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货