Re: [newbie] SQL: How to insert a string with ' inside?
From: (wrong string) ålhammar <peter.stalhammar_at_abb.senet.se>
Date: 1997/09/03
Message-ID: <340D641F.920345DA_at_abb.senet.se>#1/1
Date: 1997/09/03
Message-ID: <340D641F.920345DA_at_abb.senet.se>#1/1
You do like this
insert into person values ('foo''bar');
Yong-Shen Tang wrote:
> like this:
>
> insert into person
> values ('James', 'foo'bar')
>
> ORA-01756: xxxxxxxxxxxxxx
>
> how to solve this problem?
> thanks in advanced.
-- ***************************************** * Peter Stålhammar,Know It Mälardalen * * Peter.Stalhammar_at_knowit.se * * 0705-87 76 30 ,www.knowit.se * *****************************************Received on Wed Sep 03 1997 - 00:00:00 CEST