From: "Michel Cadot" <micadot@netcourrier.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: How to insert a ' into an field
Date: Tue, 10 Oct 2000 14:33:41 +0200
Organization: Guest of France Telecom Oleane's newsreading service
Lines: 31
Message-ID: <8rv2dm$5np$1@s1.read.news.oleane.net>
References: <39e2fa9a@news.netfab.de>
Reply-To: "Michel Cadot" <micadot@netcourrier.com>
NNTP-Posting-Host: 195.101.229.231
X-Trace: s1.read.news.oleane.net 971181303 5881 195.101.229.231 (10 Oct 2000 12:35:03 GMT)
X-Complaints-To: abuse@oleane.net
NNTP-Posting-Date: Tue, 10 Oct 2000 12:35:03 +0000 (UTC)
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300


Answer embedded.

--
Have a nice day
Michel


Oliver Huppert <ohuppert@pikon.com> a écrit dans le message : 39e2fa9a@news.netfab.de...
> Hi there
>
> I've to insert a String conaining a ' into an table.
> The SQL-Statement:
>
> insert into [table] values ('14 jours après l'implantation');

double the apostrophe:
insert into [table] values ('14 jours après l''implantation');

>
> or so
>
> don't work, because of the ' after the l. Oracle means the String ends here.
>
> Plsease help me.
>
> Nice regards
> Oliver Huppert
>
>