How to select from a table variable?

From: <michael.young_at_paetec.com>
Date: Thu, 3 Jan 2008 08:53:43 -0800 (PST)
Message-ID: <f7cfd72f-f0ab-480e-82c5-0e98b5ac201a@p31g2000hsd.googlegroups.com>


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 Received on Thu Jan 03 2008 - 10:53:43 CST

Original text of this message