[newbie] SQL: How to insert a string with ' inside?

From: Yong-Shen Tang <jeff_at_db.csie.ncu.edu.tw>
Date: 1997/08/27
Message-ID: <5u1rcu$6gm$1_at_db.csie.ncu.edu.tw>#1/1


like this:

insert into person
[Quoted] values ('James', 'foo'bar')

ORA-01756: xxxxxxxxxxxxxx

[Quoted] how to solve this problem?
thanks in advanced. Received on Wed Aug 27 1997 - 00:00:00 CEST

Original text of this message