oracle怎么判读一个数是不是小数

select decode(instr('1', '.') + sign('1'), 1, 1, 0) from dual;
返回1是整数，否则不是
create or replace function f_isnumeric(cnt varchar2) return number asres number; flag number; beginif cnt is
null thenreturn 0;
end if; select to_number(cnt) into res from dual; select decode(instr(res, '.') + sign(res), 1, 1, 0) into flag from dual; if flag = 1 thenreturn 1; else return 0;
end if;
exception
when others then return 0;
end;