Re: Help What is the SQLPLUS escape character ?

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
Use double single quotes (aka apostrophes). For example, SQL> insert into mytable values ('''ant'); 1 row created.

SQL> select * from mytable where mycol = '''ant'; mycol

John.

--
John Early      jpe1_at_lehigh.edu     x85066
Senior Programmer, Enterprise Systems Implementation
Lehigh University, Bethlehem, Pennsylvania
qotd: "The meek shall inherit the Earth when the rest of us take to the stars"