Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus and the ampersand
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>...Received on Sat Sep 20 1997 - 00:00:00 CDT
> 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.
>
>
>
>