Re: How can i store and retrieve strings with ' (Single quote) ??

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/12/12
Message-ID: <34916069.ED2D3672@gatwick.geco-prakla.slb.com>#1/1

Leonid Lamburt wrote:

> It doesn't escape the & character:
>
> select 'Johnson '& Johnson' from dual;

Quite right but if you read the question (see below), it asked how to escape a ' and mentioned nothing about an &.To insert the & sign you need to issue the command;

set scan off

Regards,

Ian

>
>
> Ian Cary <cary_at_gatwick.geco-prakla.slb.com> wrote in article
> <3487F9A4.4D27E23B_at_gatwick.geco-prakla.slb.com>...
> > Bharat Yarlagadda wrote:
> >
> > > Is there an escape char. that i can use to escape a ' in strings while
> > > storing the data. If there is any other way one could store and
>
Received on Fri Dec 12 1997 - 00:00:00 CST