Re: Special Characters

From: Don Barnwell <don_at_softadinc.com>
Date: 1996/09/19
Message-ID: <32416E71.269B_at_softadinc.com>#1/1

To insert a single-quote;

insert into table values ('Test data ''quote there''')   Returns: Test data 'quote there'

---

Don Barnwell
Senior Database Programmer
SoftAd, Inc.
Mill Valley, CA

---

Rainer Ternes wrote:
>
> Hi,
>
> I would like to select and insert special characters
> (e.g, ' ) in varchar2 fields.
> Does anybody know haw to do this?
Received on Thu Sep 19 1996 - 00:00:00 CEST