Re: How to do this as a singleton select?

• Post for FREE via your newsreader at post.usenet.com ****

"Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message news:1efdad5b.0301081021.fb21748_at_posting.google.com...
> I cant remember how to do this as one select statement.
>
> SELECT TABLE_NAME
> FROM USER_TAB_COLUMNS
> WHERE TABLE_NAME = p_tableName(this is a variable passed in)
> and COLUMN_NAME = ... however, there are 4 column_names and all of
> them have to appear.
>
> I know I can do it with 4 implicit cursors and just pass the results
> to the next, but how do I do it with a subquery?
>
> SELECT column
> into v_column
> from table
> where column = 'A'
>
> select column
> into v_column2
> from table
> where column = v_column
>
> and so on...
>
>
> I know its basic, but I cant remember how to do this. Went brain dead.

select table_name
from user_tab_columns
where table_name = p_tablename
and column_name in ('A', 'B', 'C')

or

select table_name
from user_tab_columns
where table_name = p_tablename
and column_name in (select column from table where column = v_column or column = v_column2)

Is that what you were looking for?

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=