You can select only from unnested (table expression) collection (at
least in 10gR2) . Collection should be an SQL datatype ( as opposite to
PL SQL datatype).
There are tons of examples in pl sql developer quide ,sql reference and
app dev guide - oo features.