Re: Fooling Oracle with &

From: Joel Garry <joelga_at_pebble.ml.org>
Date: 30 Apr 1998 15:10:42 -0700
Message-ID: <6iast2$uo$1@pebble.ml.org>

In article <1998043016341400.MAA11843_at_ladder01.news.aol.com>, NEWSOL97 <newsol97_at_aol.com> wrote:
>Hi all,
>
>This is probably an ancient topic but does anyone know how to express an
>& in a character string without the SQL parser trying to tokenize it? In other
>words if I had
>"Sally & Bob"
>
>What would the syntax be?
>Thanks
>Peter

set scan off or set def to some other character. See the SQL*Plus users guide and reference.

--
These opinions are my own and not necessarily those of Information Quest

jgarry@eiq.com                           http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry "See your DBA?" I AM the @#%*& DBA! Received on Thu Apr 30 1998 - 17:10:42 CDT