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: PLSQL Collection Question

Re: PLSQL Collection Question

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 14 Jun 2007 15:13:33 -0700
Message-ID: <1181859211.584533@bubbleator.drizzle.com>


amerar_at_iwc.net wrote:

> On Jun 14, 4:06 pm, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:

>> Hi,
>>
>> I have 2 collections that are basically an array of numbers.
>>
>> I'm looking for some slick code that will compare collection #1
>> against collection #2 and tell me how many elements of #1 are in #2.
>>
>> I can write some stupid FOR LOOP for WHILE LOOP with indexes and all,
>> but I was wondering if anyone has something more slick or efficient?
>>
>> Thanks!

>
> Oh yeah, I forgot to mention, this client is still on 8.1.7.......

8.1.7 has not been supported during the current millennium. The last time I saw it was more than 8 years ago. Have your client upgrade to 10gR2. This is not an environment in which you should be doing new development.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jun 14 2007 - 17:13:33 CDT

Original text of this message

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