RE: Finding Special Characters in Oracle Column

Sorry, I had nothing with which to test it; I wasn't the one with the problem.  Else my response would have been something like: "This works for me."

You might get by with pressing TAB after the [ character - that's worked for me in the past (in UNIX, though).  But that's horrible methodology from a documentation perspective, and TOAD - or something else - may manipulate that kind of tab.  But if it's a one-off, might be worth a try.

Everything I've read says that \t should work as a regex replacement for TAB.  But that's the beauty of standards: there are so many from which to choose.

Last thought on this: If you're doing this in an environment that can monkey with your \t (such as a shell command line), you may need to escape it like \\t

Dennis

From: [email protected] [mailto:[email protected]] On Behalf Of SHIVANAND BHARTI
Sent: Tuesday, July 24, 2012 11:54 AM
To: [email protected]
Subject: [toad] RE: Finding Special Characters in Oracle Column


No it does not.
Did you test it ?

From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Lovelady, Dennis E.
Sent: Tuesday, July 24, 2012 10:32 AM
To: [email protected]<mailto:[email protected]>
Subject: [toad] RE: Finding Special Characters in Oracle Column


This doesn't work for you?

select * from seasons where regexp_like (season_desc,'[\t~>*]');

or

select * from seasons where regexp_like (season_desc,'[\9~>*]');




From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of SHIVANAND BHARTI
Sent: Tuesday, July 24, 2012 10:26 AM
To: [email protected]<mailto:[email protected]>
Subject: [toad] Finding Special Characters in Oracle Column


Hi Folks ... I want to find all the records in a table( Oracle 10g)  which has TAB,~,>,* in a VARCHAR2 column.

I can do it in two separate query using regexp_like.
But I am not able to do it in one query using regexp_like.

select * from seasons where regexp_like (season_desc,'[~>*]');
select * from seasons where regexp_like (season_desc,chr(9));

Can you help me do so.

Thanks,
Shiva.

-------------------------------------------------------------------------------------

NOTE: This e-mail message contains PRIVILEGED and CONFIDENTIAL information and is intended only for the use of the specific individual or individuals to which it is addressed. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use, dissemination or copying of this e-mail or the information contained herein or attached hereto is strictly prohibited. If you receive this e-mail in error, notify the person named above by reply e-mail and please delete it. Thank you.

_____________________________________________________________
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.

-------------------------------------------------------------------------------------

NOTE: This e-mail message contains PRIVILEGED and CONFIDENTIAL information and is intended only for the use of the specific individual or individuals to which it is addressed. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use, dissemination or copying of this e-mail or the information contained herein or attached hereto is strictly prohibited. If you receive this e-mail in error, notify the person named above by reply e-mail and please delete it. Thank you.



<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>