oracle 判断字段是否为数值型



create or replace function isnumber(p_in varchar2) return number as
   i number;
 begin
   i := to_number(p_in);
   return 1;
 exception
   when others then
     return 0;
     if i = 1 then
       null;
     end if;
 end isnumber;

regexp_like(t.attr_val, '(^[+-]?\d{0,}\.?\d{0,}$)')