Finding Special Characters in Oracle Column

SHIVANAND BHARTI <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <B75962E88A72F3438A4EC07F37C0375B01C1EA@NCEXDAG02.familydollar.com>
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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.