Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to use column name from subquery result set.

729964Jan 21 2011 — edited Jan 21 2011
I have these 2 tables
SQL> select * from temp
  2  ;

TABLE_NAME                     COLUMN_NAME                    TYPE
------------------------------ ------------------------------ ------------------
------------
lst                            name                           STATUS
lst                            val

SQL> select * from lst;

TYPE                           NAME
  VAL
------------------------------ -------------------------------------------------
- ------------------------------
STATUS                         Pending
  Pendiente
STATUS                         Closed
  Cerrado
STATUS                         ABC
  ABS
I want to select column_name from temp table and generate select statements.
select name from lst;

select (select COLUMN_NAME from temp where rownum<2) from lst;
SQL> select (select COLUMN_NAME from temp where rownum<2) from lst;

(SELECTCOLUMN_NAMEFROMTEMPWHER
------------------------------
name
name
name
output I expect is
SQL> select name from lst;

NAME
--------------------------------------------------
Pending
Closed
ABC
This post has been answered by MichaelS on Jan 21 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2011
Added on Jan 21 2011
6 comments
4,271 views