添加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 * from dual where to_num_yhm(字段名);