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

Home -> Community -> Usenet -> c.d.o.server -> Insert quote into table problem

Insert quote into table problem

From: PeterHageman <P.J.J.Hageman_at_ict.hva.nl>
Date: 1 Jul 2001 05:30:54 -0700
Message-ID: <1a4cb310.0107010430.7b6843b9@posting.google.com>

I'm trying to insert a row in a table, with a field that contains a quote.
Sql looks like this:
insert into pctable('1011 KN','1',' 8','10','Amsterdam ','Plein '40-'45'); I get an error ORA 01756: quoted string not properly terminated. How can I get the field with 'Plein '40-'45 into the table?

Greetz,

Peter Hageman
Hogeschool van Amsterdam Received on Sun Jul 01 2001 - 07:30:54 CDT

Original text of this message

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