Re: sqlplus and the ampersand

From: N.Prabhakar <n_prabhakar_at_post1.com>
Date: 1997/09/24
Message-ID: <01bcc8f0$99e725a0$a94718d2@regresea>#1/1

Hi there,

All you need to do is to set the define character.

set define "^"

By default '&' is the define character. This can be replaced by the above set command. Hope this is useful to you.

Regards

N.Prabhakar

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 Wed Sep 24 1997 - 00:00:00 CDT