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
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 SpenceReceived on Tue Sep 09 1997 - 00:00:00 CEST