Its not so clear, What you want exactly can you show the command here what you tried and what you get any error or something
I am working on a view
In that view temp table exists
My view is not fetching any data
So any possible ways of fetching the data from the temp table?
What is the Temporary table on Commit setting
what about you Query from Temp table alone, it that return you some result
SQL> create global temporary table temp_emp on commit preserve rows as select * from emp; Table created. SQL> create view v_temp_emp as select * from temp_emp; View created. SQL> select count(*) from v_temp_emp; COUNT(*) ---------- 15
I am looking data for bom_small_expl_temp table
in my previous post I show you example how temporary tables work, If your base table have data then it will populate through view.
so first you have to find out how your temp table work. what is the DDL when rows get deleted from Temp Table..