SQL Language (MOSC)

MOSC Banner

How to use REGEXP_LIKE to find out if a VARCHAR2 field contains the non-printable characters (decima

edited Jun 8, 2011 4:00AM in SQL Language (MOSC) 3 commentsAnswered
All,

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

 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center