Re: Temporary tables in Oracle

From: F Lange <flange_at_pt.lu>
Date: 1997/09/24
Message-ID: <01bcc91e$91982380$8cd79ac2@fql10>#1/1

Hi,
Why do you need that ?

you can used select in the from clause.

			select a , b , c , s.d , t.e , u.f
			from ( select ... a , .... b , .... c from ..... where ......) ,  s , t
, u 
			where ....

	Or in your application don't you miss some aggregation table ?

-- 
Regards F. Lange Certified DBA.
29A route du vin.
L5450 Stadtbredimus.
Grand Duchy of Luxembourg.
flqnge_at_pt.lu
(int) 352 697412
(cel) 352 021193652
Phone numbers are variable length.
Luxembourg is a small country of 80 miles on 60 miles between France,
Germany and Belgium.


Mahesh Patel <mpatel_at_dbna.com> wrote in article <342909DF.55A3_at_dbna.com>...


> I have Sybase and Informix experience and am trying to write a complex

> query in a Stored procedure.  How do I create and use temporary tables

> in Oracle.  

> 

> Hard to believe but it seems that Oracle does not have temperory tables

> like Sybase and Informix have. 

> 

> Any help will be appreciated.

> 

> 

> - Mahesh

> mpatel_at_dbna.com

>

Received on Wed Sep 24 1997 - 00:00:00 CDT