Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to do this as a singleton select?
"Greg Akins" <insomnia_at_cvzoom.net> wrote in message
news:3e1c7444$1_at_post.usenet.com...
> **** 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
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
The answer is not an 'IN' Since I need all of them. IN is 'A' or 'B' or 'C'
I need all 4 of them. Received on Wed Jan 08 2003 - 18:05:34 CST