Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help What is the SQLPLUS escape character ?
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 Wed May 05 1999 - 21:29:57 CDT