oracle 过滤非法字符 解决ora-01722
添加FUNTION:
create or replace function to_num_yhm(tonum varchar2) return number is
str varchar2(1024);
Result number;
begin
begin
Result :=to_number(tonum) ;
exception
when others then
Result := 0 ;
end;
return Result ;
end to_num_yhm;
过滤非法字符:
select *
原创
2020-08-12 15:43:41 ·
491 阅读 ·
0 评论