Re: sqlplus and the ampersand

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

Or, if you know you're not going to prompt for anything, just do:

SET DEF OFF That turns off the capability altogether. You can always turn it back on again if you need it. Then you don't have to worry about embedded '$' signs, either...:)

> 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.
> >
> >
> >
> >
 

-- 
Leslie Dreyer Kalra
Techies, Inc.
lbd_at_techiesinc.com