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 -> How to insert a ' into an field

How to insert a ' into an field

From: Oliver Huppert <ohuppert_at_pikon.com>
Date: Tue, 10 Oct 2000 14:27:24 +0200
Message-ID: <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');

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:27:24 CDT

Original text of this message

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