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