How to use REGEXP_LIKE to find out if a VARCHAR2 field contains the non-printable characters (decima
I would like to use REGEXP_LIKE in an Oracle database version 10.2.0.4 to find out if a VARCHAR2 field contains the non-printable characters (decimal 0 through 31) and I was not able to do it.
Would you please let me know what is the best way to do that.
select 'TRUE' from dual where REGEXP_LIKE('Test Text 123', '.*[\x00-\x1F]+.*');
But this query always return true !
Thanks in advance !,
Tran