Re: [newbie] SQL: How to insert a string with ' inside?
From: Art Clarke <fool_at_ofb.net>
Date: 1997/08/27
Message-ID: <5u20no$h01_at_gap.cco.caltech.edu>#1/1
Date: 1997/08/27
Message-ID: <5u20no$h01_at_gap.cco.caltech.edu>#1/1
insert into person values ('James', 'foo''bar');
/* Note the '' to insert a single ' */
Yong-Shen Tang (jeff_at_db.csie.ncu.edu.tw) wrote:
> like this:
> insert into person
> values ('James', 'foo'bar')
> ORA-01756: xxxxxxxxxxxxxx
> how to solve this problem?
> thanks in advanced.
--Received on Wed Aug 27 1997 - 00:00:00 CEST