Table name in from clause
846947Apr 3 2012 — edited Apr 3 2012Hi Gurus,
Each day I am creating a table dynamically and the table name is stored in log table.
End of the day I want to see that tables data(want to create a report based on that table).
select * from (
select table_name from my_log
where created_on=sysdate and table_name like '%sunil%');
As we know, it will not work in sql, and I dont want to use plsql.
Is there any way to get my requirements only using sql.
Thanks,
Sunil