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