Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus and the ampersand

Re: sqlplus and the ampersand

From: Anon <pjbump_at_i1.net>
Date: 1997/09/20
Message-ID: <01bcc5e9$1ebebdc0$d33ae6cf@default>#1/1

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 Sat Sep 20 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US