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


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

Original text of this message