oracle regexp_like¶
check new line¶
SELECT rowid, t.*
FROM csv t
WHERE regexp_like (ha, chr(10) || '|' || chr(13) || '|' );
check digits only¶
SELECT rowid, t.*
FROM csv t
WHERE regexp_like (ha, '^[0-9]+$');
oracle regexp_replace¶
UPDATE csv set h =
REGEXP_REPLACE(h, chr(10) || '|' || chr(13), null)
WHERE REGEXP_LIKE (h, chr(10) || '|' || chr(13));
Reference¶
https://regexr.com/