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

From: Kevin Michael Vail <kevin_at_vailstar.com>
Date: 1997/09/09
Message-ID: <kevin-0909972006340001_at_200.200.100.102>#1/1


In article <5u1rcu$6gm$1_at_db.csie.ncu.edu.tw>, 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.

insert into person
values ('James', 'foo''bar')

This really should be in a FAQ somewhere, if it isn't already.

-- 
Kevin Michael Vail    | I would rather have a mind opened by wonder
kevin_at_vailstar.com    | than one closed by belief.   -- Gerry Spence
Received on Tue Sep 09 1997 - 00:00:00 CEST

Original text of this message