SQL & PL/SQL

Hi,

Can someone tell me how can I create a collection of records with distinct values. As the cursor may have duplicate data so need to check collection of records if the data does not exists then add it else skip. Any idea on how to achieve this. The final collection will store NUMBERS only.

I know in java and other programming languages you can have a map, arraylist which lets you check if the element already exists then don't add but how do I do it in PL/SQL.


Thanks