Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> query special character

query special character

From: Tuan Tran <tuan.tran_at_verizon.net>
Date: 21 Jul 2001 00:43:47 -0700
Message-ID: <4a17640d.0107202343.5931a3e@posting.google.com>

Please help.
I having problem with @ special character in my database.

when I do a select statement in sqlplus select * from subscribers
where email = 'johndoe_at_yahoo.com';
I got no rows selected from the server.

but if I do
select * from subscribers
where email like 'johndoe%';
then the server returned:
EMAIL



johndoe_at_yahoo.com

is there a way where I can do the first query (select * from subscribers where email = 'johndoe_at_yahoo.com' ) and get the record back?

Thanks in advance. Received on Sat Jul 21 2001 - 02:43:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US