Re: Insert ampersand into a field

From: Jeroen van Veldhuizen <Jeroen_at_vanVeldhuizen.org>
Date: Sat, 30 Jun 2001 18:20:48 +0200
Message-ID: <3B3DFC60.40509_at_vanVeldhuizen.org>


Greg Kearney wrote:

> How do you insert an ampersand (&) into a field with the database asking for
> the input value?

I assume you use a script that is run from SQL*Plus. You can disable scanning for variables (which are normally marked by &var_name) by starting your script with 'set scan off'. If you need variables in your script, you can change the &-indicator to something else (like '#') by using: 'set define #',

Hope this helps.

Jeroen van Veldhuizen
J.vanVeldhuizen_at_Itude.com
Oracle Consultant Received on Sat Jun 30 2001 - 18:20:48 CEST

Original text of this message