From: Ian Cary <cary@gatwick.geco-prakla.slb.com>
Subject: Re: How can i store and retrieve strings with ' (Single quote) ??
Date: 1997/12/12
Message-ID: <34916069.ED2D3672@gatwick.geco-prakla.slb.com>#1/1
References: <34844EA3.6A9A@ford.com> <3487F9A4.4D27E23B@gatwick.geco-prakla.slb.com> <01bd04de$c5da70c0$0d87c584@buggs>
To: Leonid Lamburt <ll01@gte.com>
Organization: Geco-Prakla
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server



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@gatwick.geco-prakla.slb.com> wrote in article
> <3487F9A4.4D27E23B@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
>