Re: inserting a ' (apostrophe) in a table

From: <mjain_at_my-dejanews.com>
Date: Tue, 17 Nov 1998 00:29:16 GMT
Message-ID: <72qg0s$fjf$1@nnrp1.dejanews.com>

**A copy of this message is being sent to "Jeff Howey" <jeffery.howey_at_mci.com>

Jeff,

    To insert apostrophe you need to repeat it by specifying it twice in the insert statement.

Look at the following example:-

SQL> create table apostrophe ( col1 varchar2(20) )   2 /

Table created.

SQL> insert into apostrophe values ( 'to insert a '' test');

1 row created.

SQL> select * from apostrophe;

COL1

---

to insert a ' test

SQL> drop table apostrophe
  2 /

Table dropped.

SQL> hope this is helpful,

Manoj Jain
Oracle Certified Professional - OCP DBA Chauncey Certified Oracle7 DBA

In article <vF042.211$k25.361_at_pm01nn>,
  "Jeff Howey" <jeffery.howey_at_mci.com> wrote:
> Hi! I need to know how to insert a ' into a table field... i've tried
> using a double and it didn't work... any hints?
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 16 1998 - 18:29:16 CST