SELECT * FROM 表名 WHERESELECT * FROM TABLE WHERE REGEXP_SUBSTR(列名, '^[0-9\.\-]\d*\.{0,1}\d+$') IS NOT NULL;