Hi All
I need to pass the below TABLE_NAME to the From clause of another SQL statement.
select TABLE_NAME from all_tab_columns
where column_name like 'ORDER_ID'
and table_name like 'ABC%'
select formula_id
from TABLE_NAME -- I need to pass TABLE_NAME to this Query see the TABLE_NAME from the above Query
where formula_id in (select FORMULA_ID from XXC_TABLE where formula_name like 'HST%')