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: Dan Clamage <clamage_at_mime.dw.lucent.com>
Date: 1997/09/18
Message-ID: <01bcc43c$cbe2c6d0$54110b87@clamagent>#1/1

From "SQL*Plus User's Guide and Reference" Chapter 6 Command Reference, p6-58
SET command, DEFINE and ESCAPE system variables:

DEFINE sets the character used to prefix substitution variables. ESCAPE defines the character you enter as the escape character. Use it before the substitution character as an ordinary character rather than as a request for variable substitution.

SHOW ALL shows you the values for these (and other) SET parameters.

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. ")
Received on Thu Sep 18 1997 - 00:00:00 CDT

Original text of this message

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