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 -> Help What is the SQLPLUS escape character ?

Help What is the SQLPLUS escape character ?

From: Seigmund Akinwande Johnson <asjohns_at_midway.uchicago.edu>
Date: Mon, 26 Apr 1999 17:49:57 GMT
Message-ID: <FAt5M6.D5M@midway.uchicago.edu> 





I need to know what is escape character in oracle, I have a table which has
data in it with apostrophes.



'ants


so I can't do   (select  * from table  where col like  ' 'ant' ')



SAJ




Received on Mon Apr 26 1999 - 12:49:57 CDT












Original text of this message













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