Xref: alice comp.databases.oracle.misc:30599 comp.databases.oracle.server:48397 comp.databases.oracle.tools:24401
Path: alice!news-feed.fnsi.net!netnews.com!cyclone.news.idirect.com!island.idirect.com!nntp.flash.net!news.flash.net!not-for-mail
Message-ID: <37310046.C08EF49C@flash.net>
From: Al Ruiz <arruiz@flash.net>
X-Mailer: Mozilla 4.04 [en]C-NECCK  (Win95; I)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools
Subject: Re: Help What is the SQLPLUS escape character ?
References: <FAt5M6.D5M@midway.uchicago.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 16
Date: Thu, 06 May 1999 02:29:57 GMT
X-Complaints-To: abuse@flash.net
X-Trace: news.flash.net 925957797 38.30.171.94 (Wed, 05 May 1999 21:29:57 CDT)
NNTP-Posting-Date: Wed, 05 May 1999 21:29:57 CDT
Organization: FlashNet Communications, http://www.flash.net

Use select * from table where col like '''ant''';

Al Ruiz

Seigmund Akinwande Johnson wrote:

> 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