Oracle判断是否为数字或数字型字符串
with t as(
select '21.43243' c from dual)
select *
from t
where regexp_like(c,'^(([0-9]+)([.]([0-9]+))?|([.]([0-9]+))?)$');
with t as(
select '21.43243' c from dual)
select *
from t
where regexp_like(c,'^(([0-9]+)([.]([0-9]+))?|([.]([0-9]+))?)$');