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

Home -> Community -> Usenet -> c.d.o.server -> Re: Escaping the &

Re: Escaping the &

From: Girts Graudins <ggraudins_at_my-deja.com>
Date: 2000/04/10
Message-ID: <8ct45j$dag$1@nnrp1.deja.com>#1/1

> If I attempt to insert 'Sound & Music', Oracle always prompts me for
 the
> value of Music
> because it thinks I'm specifying a variable.

All the above solutions will work, but

SQL> set scan off;

is the one that targets the real problem. Set scan off turns off the feature of SQL*Plus that looks for '&name' and interprets them as variables. This is especially useful if you want to compile a web page with lots of special characters like &nbsp; &amp;, etc.



Girts Graudins
Consulant
The Exeter Group, Inc.
ggraudins_at_hotmail.com
http://www.exetergroup.com/

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Apr 10 2000 - 00:00:00 CDT

Original text of this message

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