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

PLSQL Collection Question

From: <amerar_at_iwc.net>
Date: Thu, 14 Jun 2007 14:06:07 -0700
Message-ID: <1181855167.948272.273480@d30g2000prg.googlegroups.com>


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! Received on Thu Jun 14 2007 - 16:06:07 CDT

Original text of this message

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