Re: sqlplus and the ampersand

Another solution that may suit your needs even better is to issue the following:

SET SCAN OFF This command will suppress the process of looking for paramters.

In article <01bcc5e9$1ebebdc0$d33ae6cf_at_default>,   "Anon" <pjbump_at_i1.net> wrote:
>
> Before your select statement, issue the following SQL*Plus command:
> SET DEFINE $
>
> This changes the replacement character from the default of & to a $.
> --
> Phillip Bump
> Senior Principal Consultant
> Oracle Consulting
> ----------------------------------------------------------------------------
> -----------------------------------------------------------------------
> The opinions expressed are my own and do not necessarily reflect those of
> Oracle Corporation
>
> Jenny Farnham <farnham_at_spot.Colorado.EDU> wrote in article
> <5vpk76$rq3_at_peabody.colorado.edu>...
> > How do you keep the ampersand "&"
> > from literally being interpreted
> > in an IN statement. When the sqlplus
> > code is run... it is prompting the
> > user for a value. For example:
> >
> > select count(*)
> > from companys
> > where name in ('Baskin & Robbins');
> >
> > This will generate a prompt. We tried
> > double quotes too (ex. ")
> >
> > Thanks in advance.
> >
> >
> >
> >

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet