Re: Insert single quote

From: Paul Druker <pdruker_at_metaway.com>
Date: 2000/04/19
Message-ID: <Z_6L4.10043$cZ.18090@typhoon.southeast.rr.com>#1/1

You need to use four quotes:

insert into tablename (columname)
values ('''');

Paul

"Marty Provost" <liquidgolf_at_earthlink.net> wrote in message news:kG3L4.61705$q67.917595_at_newsread2.prod.itd.earthlink.net...
> Stupid question...
>
> What's the syntax to insert a string that contains a single quote?
>
> Example:
>
> TABLENAME
> columnname varchar2(100)
>
> insert into tablename (columname)
> values ('help me insert this ' into this column');
>
> Thanks in advance,
> Marty
>
>
Received on Wed Apr 19 2000 - 00:00:00 CDT