Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Use collection in JOIN clause ?

452507Oct 18 2005 — edited Oct 19 2005
Is it possible to use a collection in a JOIN clause, to join tables in the database against data in a collection ?

What I want to do is execute a query to retrieve a two-column result, into some form of temporary storage (a collection ?), and then re-use that common data in many other queries inside a PL/SQL block.

I could use temporary tables, but I'd like to avoid having to create new tables in the database, if possible.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2005
Added on Oct 18 2005
7 comments
819 views