Re: Help What is the SQLPLUS escape character ?
From: Serge <rulsl_at_chat.ru>
Date: Mon, 26 Apr 1999 23:13:14 +0400
Message-ID: <7g2du9$4g4$1_at_news2.aha.ru>
Date: Mon, 26 Apr 1999 23:13:14 +0400
Message-ID: <7g2du9$4g4$1_at_news2.aha.ru>
Try that
select * from table where col like '''ant'''
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 Mon Apr 26 1999 - 21:13:14 CEST