Re: Insert ampersand into a field

i don't know what exactly your code is doing, so this might not apply to you, but i've also seen a "workaround" where you isolate the & between single quotes, e.g., if you want to return a string like "this & that" you could

select 'this ' || '&' || ' that' and sqlplus should not consider it a parameter in this case. kind of hack, but ..

Jeroen van Veldhuizen <Jeroen_at_vanVeldhuizen.org> wrote in message news:<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 Mon Jul 02 2001 - 17:51:10 CEST