判断字段值是否为数字
SELECT *
FROM tableName t
where NOT REGEXP_LIKE(t.source_transaction_id, '^(+ [ 0 - 9 ] +) $')
备注说明:oracle 判断字段为非数字
SELECT *
FROM tableName t
where NOT REGEXP_LIKE(t.source_transaction_id, '^(+ [ 0 - 9 ] +) $')
备注说明:oracle 判断字段为非数字