insert varchar containing single quote (apostrophe) into oracle???
From: <jeffchirco_at_gmail.com>
Date: 16 May 2005 14:45:02 -0700
Message-ID: <1116279902.368513.322730_at_z14g2000cwz.googlegroups.com>
[Quoted] How do I insert a string value into Oracle that contains a single quote (apostrophe). Say I want to enter Jeff's into the database. I tried using escape character like;
Date: 16 May 2005 14:45:02 -0700
Message-ID: <1116279902.368513.322730_at_z14g2000cwz.googlegroups.com>
[Quoted] How do I insert a string value into Oracle that contains a single quote (apostrophe). Say I want to enter Jeff's into the database. I tried using escape character like;
insert into table1
values ('Jeff\'s');
ERROR:
[Quoted] ORA-01756: quoted string not properly terminated
How else do you do this? Received on Mon May 16 2005 - 23:45:02 CEST