Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How do you insert a ' character into the database?
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