Re: How to select from a table variable?

From: <>
Date: Thu, 03 Jan 2008 20:11:22 +0100
Message-ID: <>

On Thu, 3 Jan 2008 08:53:43 -0800 (PST), "" <> wrote:

>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.
> Mike

Your question is very unclear as it lacks an example. However, it strongly looks like you are referring to the 'dynamic in list' problem.
Search for this string on and you will find many working solutions.
If that isn't what you mean: crystal balls have worn out in the previous millenium.
Your description needs to be less vague.

Sybrand Bakker
Senior Oracle DBA
Received on Thu Jan 03 2008 - 13:11:22 CST

Original text of this message