This question already has answers here: Oracle – How to find carriage return, new line and tab using REGEXP_LIKE? (2 answers) Closed 16 days ago. I’m using the following regex in Oracle DB under CLOB datatype column: SELECT CASE WHEN COUNT(*) > 0 THEN 1 ELSE 0 END AS contains_extended_unicode FROM my_table WHERE REGEXP_LIKE(TO_CHAR(my_column), ‘[^[:print:]rnt]’); […]