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!

collections and selection from tables into the collections

774512May 27 2010 — edited May 28 2010
Hey Guys,

I am looking for a way to select id's from a table into some sort of collection, so that I can then use those id's in a couple of delete statements.

What is the best collection to store a temporary list of id's?

Whats the syntax to insert/select into that collection and then how do you join on it?

Thanks,
Ian
This post has been answered by Tubby on May 28 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 25 2010
Added on May 27 2010
10 comments
1,257 views