Home » SQL & PL/SQL » SQL & PL/SQL » How to put query result into a table (Oracle 10g)
How to put query result into a table [message #321591] Tue, 20 May 2008 15:48 Go to next message
dk31
Messages: 2
Registered: May 2008
Junior Member
Hi All,

I dont know how to create temp table using query result.
query as follows:

select a.wrk_inst, a.type_cd, a.idno, a.idno_wop, a.valid, a.sort
from work a, temp_wrk_insts b
where a.WRK_INST=b.WRK_INST and a.TYPE_CD ='B'

Please help me.
Thanks
Re: How to put query result into a table [message #321593 is a reply to message #321591] Tue, 20 May 2008 15:52 Go to previous message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Oracle rarely, rarely ever needs any "temp table".

What problem are you really, really trying to solve?
Previous Topic: Problem with FORALL
Next Topic: retrieve duplicate rows from a query result
Goto Forum:
  


Current Time: Wed Dec 07 06:41:30 CST 2016

Total time taken to generate the page: 0.15479 seconds