Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Insert quote into table problem
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