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   &, 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