How to select from a table variable?

How can I 'select' all items from a table variable?
Actually, I want this syntax to use to create a subquery that I can
use to join against.

I have a CSV string, and I wanted to use either
DBMS_UTILITY.comma_to_table or HTMLDB_UTIL.STRING_TO_TABLE to get the
values in a table format. Then I wanted to use this table variable
(collection) as if it were an actual data table.

From everything I have seen, this (select queries or DML against table
collections) is not directly possible. It seems that I must basically
loop through all items in the table, and either use a pipelined
function and/or store the items in a temporary table.

Is this correct and/or recommended, or am I thinking about this all
wrong? What are the relevant considerations for the various
approaches to do what I need?

I'm using Oracle 10gR2.

TIA,
Mike
.

Relevant Pages