Re: Help What is the SQLPLUS escape character ?

How do you read in other atypical characters, such as parentheses, semicolons, blank lines, dashes, etc? Is their a universal SQL escape character? I'm trying to

read in .txt files containing poems and prose into a field of LONG datatype, and find myself just finding & replacing the offensive characters.

John P. Early wrote:

> 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
> -----
> 'ant
>
> 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"
Received on Mon Apr 26 1999 - 17:05:24 CDT