Re: simple and emergency!!!

From: TurkBear <johng_at_mm.com>
Date: Mon, 27 Dec 1999 22:32:07 GMT
Message-ID: <3868e85d.19423169@super.news-ituk.to>

ibm_97_at_yahoo.com wrote:

>How to insert single quote to a VARCHAR2 column?
>
>tableA(colA varchar2(20)), how to insert zx'123'zx to colA?
>
>Thanks!! Pls email me a copy also!
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

Use double quotes around whole string that includes single quotes.. like:
insert into tableA(colA) values "zx'123'zx";

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Dec 27 1999 - 16:32:07 CST