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: <amerar_at_iwc.net>
Date: Thu, 14 Jun 2007 14:09:01 -0700
Message-ID: <1181855341.577409.10380@a26g2000pre.googlegroups.com>


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....... Received on Thu Jun 14 2007 - 16:09:01 CDT

Original text of this message

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