RE: RE: Finding Special Characters in Oracle Column

From: [email protected] [mailto:[email protected]] On Behalf Of Rich Jesse
Sent: Tuesday, July 24, 2012 3:00 PM
To: [email protected]
Subject: Re: [toad] RE: Finding Special Characters in Oracle Column



Shiva writes:

> This does not work for me too.
> I have Toad 9.7.2.5 and oracle 10g DB.
> select 1 FROM DUAL where regexp_like ('ABC'||chr(9)||'DEF','[\t~*>]');

True -- "\t" is not defined in the regexp for Oracle.


Au contraire!  http://docs.oracle.com/cd/E14571_01/integration.1111/e10224/bam_app_icommand.htm shows:
\t

Matches a tab character. Equivalent to \x09 and \cI.





<BR>_____________________________________________________________
<FONT size=2><BR>
DTCC DISCLAIMER: This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error, please notify us immediately and delete the email and any
attachments from your system. The recipient should check this email
and any attachments for the presence of viruses.  The company
accepts no liability for any damage caused by any virus transmitted
by this email.</FONT>