How to select from a table variable?
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