Re: PL/SQL Collections

Paul Rowe wrote:

> I have questions regarding PL/SQL Collections:
>
> 1. Is there an easy way to concatenate two like-typed collections
> together? I have to use a FOR LOOP which may not be efficient.

It is very efficient as it takes place entirely in memory. You'll see almost no performance hit doing it.

>
> 2. Is there an anyway to put a collection into an IN clause? For
> instance, if I have a collection of varchar2 objects, and I want to
> execute a query like SELECT * from aTable where identifier IN
> <collection> Is there an efficient way to do this?
>
> sincerely,
>
> paul_at_paulrowe.com

There is and it was posted here on the usenet within the last 60 days or so. Likely also you will find it at asktom.oracle.com.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)