Invalid number
尝试将字符串转换为数字失败，因为字符串不表示有效数字。
SELECT col FROM table_name WHERE NOT REGEXP_LIKE(col, '^[0-9.]+$') AND col IS NOT NULL FETCH FIRST 20 ROWS ONLY;SELECT data_type FROM dba_tab_columns WHERE table_name = 'TABLE_NAME' AND column_name = 'COL_NAME';