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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Doubt about charecter

Re: Doubt about charecter

From: Scott Canaan <srcdco_at_ritvax.isc.rit.edu>
Date: Tue, 13 Feb 2001 10:22:37 -0800
Message-ID: <F001.002B2B9F.20010213095046@fatcity.com>




Use 'AAA_#989',  the _ means any 1 character substitution.
Eriovaldo do Carmo Andrietta wrote:

I have a problem where in a statment
of sql the DB Oracle doesn´t get the line in the follow situation
:     select name     from table1     
where field = 'AAA  #989'; I think that between A and # exist
some strange character that i can´t identify it .. How can I
do it ? Regards Eriovaldo 

--
Scott Canaan (srcdco@rit.edu)
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  INET: srcdco@ritvax.isc.rit.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Feb 13 2001 - 12:22:37 CST

Original text of this message

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