Re: Inserting a ' in a VARCHAR

From: Markus Schwabe <mschwabe_at_gscout.de>
Date: 2000/06/08
Message-ID: <8hng7v$ig0$1@news4.muc.eurocyber.net>#1/1

SQL> create table dummy (Dummy_col varchar2(100));

Tabelle wurde angelegt.

SQL> insert into dummy (dummy_col)
  2 values ('My name is Troy O''Leary');

1 Zeile wurde erstellt.

SQL> select * from dummy;

DUMMY_COL

---

My name is Troy O'Leary

SQL> Hth
Markus

Joe Patterson <jpatterson_at_elitra.com> schrieb in im Newsbeitrag: jQx%4.400$N25.86337_at_news-west.eli.net...
> How does one include a ' (single quote, apostrphy) directly into a VARCHAR?
> Is there a way to escape the quote like \' or something? I want to avoid
> converting the ' to a work like prime or apostrophy.
>
> Anyone know how to do this?
>
> TIA,
> Joe
>
>
Received on Thu Jun 08 2000 - 00:00:00 CDT