Xref: alice comp.databases.oracle.tools:39441
Newsgroups: comp.databases.oracle.tools
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news1.radix.net!news.er.usgs.gov!news
From: Brian Peasland <peasland@edcmail.cr.usgs.gov>
Subject: Re: Operators
Content-Type: text/plain; charset=us-ascii
Message-ID: <3898486B.77919A27@edcmail.cr.usgs.gov>
Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739)
Content-Transfer-Encoding: 7bit
Organization: Raytheon Systems
X-Accept-Language: en
References: <38982a8b$0$75315@news2.zeelandnet.nl>
Mime-Version: 1.0
Date: Wed, 2 Feb 2000 15:08:27 GMT
X-Mailer: Mozilla 4.61 [en] (WinNT; U)
Lines: 18

Use dynamic SQL (DBMS_SQL package) to dynamically change the operator.

HTH,
Brian


Willem Visser wrote:
> 
> Hai Everybody
> 
> I have a question how can you change a operator in a select statement into
> a global.variable ?
> 
> If this is possible then it wil save a lot of programming for me.
> 
> Thank you fo helpint with this problem
> 
> Greetings Willem Visser