Oracle 判断是否为数字，包括小数点

select * from SAMPLE_INFO_YPLIST s where s.SAMPLE_BATCH_NO = 'PBMK210618-AK853-ZX01-0201' and (trim(translate(s.OD260_230, '0123456789.', ' ')) is not null or trim(translate(s.O28S_18S, '0123456789.', ' ')) is not null or trim(translate(s.OD260_280, '0123456789.', ' ')) is not null or trim(translate(s.VOLUME, '0123456789.', ' ')) is not null or trim(translate(s.CONCENTRATION, '0123456789.', ' ')) is not null or trim(translate(s.TOTAL_QUANTITY, '0123456789.', ' ')) is not null or trim(translate(s.FRAGMENT_SIZE, '0123456789.', ' ')) is not null);