Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How do you insert a ' character into the database?

Re: How do you insert a ' character into the database?

From: Rajagopal Venkataramany <net_scan_at_my-deja.com>
Date: Thu, 28 Sep 2000 02:39:10 GMT
Message-ID: <8qub0e$3m5$1@nnrp1.deja.com>

Hi,

  to do the trick in a different way, try using chr(39) to get the   same result...

In article <39D1FBB1.F0B00816_at_bt.com>,
  trevor burkin <trevor.2.burkin_at_bt.com> wrote:
> insert into table values ('''');
>
> will do the trick
>
> Shaun Campbell wrote:
>
> > Can anyone tell me whether it is possible to enter a ' single quote
> > character into a database column?
> >
> > Regards
> >
> > Shaun Campbell
>
>

--
Regards
Rajagopal Venkataramany


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Sep 27 2000 - 21:39:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US