Re: Help What is the SQLPLUS escape character ?
From: Al Ruiz <arruiz_at_flash.net>
Date: Thu, 06 May 1999 02:29:57 GMT
Message-ID: <37310046.C08EF49C_at_flash.net>
Date: Thu, 06 May 1999 02:29:57 GMT
Message-ID: <37310046.C08EF49C_at_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
Received on Thu May 06 1999 - 04:29:57 CEST