Re: sqlplus and the ampersand

Can also SET SCAN OFF, to turn off scanning for substitution variables and parameters.

Anon 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.
> >
> >
> >
> >
Received on Mon Sep 22 1997 - 00:00:00 CDT