A non-numeric character was found where a numeric was expected
在日期或数字解析期间,根据格式模型在预期数字的位置发现了非数字字符。
SELECT * FROM nls_session_parameters WHERE parameter LIKE 'NLS_%FORMAT%';-- 12c+: SELECT col FROM t WHERE VALIDATE_CONVERSION(col AS DATE, 'YYYY-MM-DD') = 0;