Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: AMPERSAND in where clause mistaken for variable name

Re: AMPERSAND in where clause mistaken for variable name

From: David Richardson <drichardson_at_all-4-one.com>
Date: 1997/05/18
Message-ID: <5lnagq$o54$2@news8.gte.net>#1/1

Jude,

Prior to the query enter the following:

        set define ~

This will change the define symbol from & to ~ (tilde). You may use any character that you want. This must be placed inside of your sql file and will remain set until the seesion is over or you execute "set define" again.

DER

-- 
David Richardson
2026 Aquia Drive
Stafford, VA 22554
1-800-425-6719
drichardson_at_all-4-one.com
http://www.all-4-one.com
Received on Sun May 18 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US