Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to insert a ' into an field

Re: How to insert a ' into an field

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 10 Oct 2000 14:33:41 +0200
Message-ID: <8rv2dm$5np$1@s1.read.news.oleane.net>

Answer embedded.

--
Have a nice day
Michel


Oliver Huppert <ohuppert_at_pikon.com> a écrit dans le message : 39e2fa9a_at_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
>
>
Received on Tue Oct 10 2000 - 07:33:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US