Skip to Main Content
Forums

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!

select from another select statement

Mrudula BandaruJun 9 2016 — edited Jun 11 2016

Hi All,

I have table1 in which I have a column which has list of tables.

From I need to have select on this column to retrieve the table content

select * from (select TABLE_NAME from TEST1);

This just gives TABLE_NAME value but not the records from table name...Can anyone let me know what is that I am missing..

Thanks in advance
This post has been answered by Vysakh Suresh - 3035408 on Jun 9 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2016
Added on Jun 9 2016
10 comments
1,575 views