Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary tables in Oracle

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US