Re: Inserting text with single quote - newbie

Use two single quotes. Example:

SQL> create table T1 (col1 varchar2(30));

Table created.

SQL> insert into t1 (col1) values ('He''ll');

1 row created.

SQL> select * from t1;

COL1

THT. Guang

"Chuck B" <chuckbayes_at_earthlink.net> wrote in message news:740defe3.0108220834.74b47168_at_posting.google.com...
> Hi all,
> Ok, this one's kicking my butt. How do I insert text (like the
> word "He'll") into a field? As background info, I get a text file
> that contains names with accent characters. I run that through a unix
> script to create a series of insert statements. My problem is that
> when one of these names comes through it's crashing the insert
> statement because of an unmatched single quote.
>
> TIA,
>
> Chuck
Received on Wed Aug 22 2001 - 19:03:09 CEST