Skip to content

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/