Re: how to insert a single quotes in to a table using SQL?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 12 Aug 2002 10:18:53 -0700
Message-ID: <92eeeff0.0208120918.36960e97@posting.google.com>

Richard Foote <Richard.Foote_at_oracle.com> wrote in message news:<3D577FC3.60D198A3_at_oracle.com>...
> insert into table values ('''');
>
> Cheers
>
> Richard
>
> vismay wrote:
> >
> > dear sir,
> > i want to insert into a table a string (don't worry?) but due to
> > single quotes (') the string terminated before it is supposed to. so
> > please help me and send me how to insert a single quotes in to a
> > string.
> > thaniking you.
> > vismay
> --

Or you could also use CHR(39) to replace ' like insert into foo (test_) values ('Don'||CHR(39)||'t worry');

SQL> Select * from foo;
test_

---

Don't worry

//Rauf Sarwar Received on Mon Aug 12 2002 - 12:18:53 CDT