Re: Creating temporary tables that only exists during the query.

From: Mike Adams <103701.1437_at_compuserve.com>
Date: 1998/03/12
Message-ID: <350842E5.B90B124E@compuserve.com>#1/1

I too would love to see the answer to this one. I don't believe there is a way to do this in oracle. MS SQL allows you to do this and it extremely helpful. We have a intranet application the uses MS SQL as the back ended. We use temp tables to query off sub sets from large tables then run analysis on the smaller tables. It is a lot easier to break a query up into parts then try to write one query and have it perform adequately

Deryl Banuelos wrote:

> Long ago when ships were tall and Oracle was 6.0 my instructor showed
> us a query example that created a temporary table that once the query
> was
> over the
> table was gone. I have an application request for such a procedure.
> Does
> anyone
> know how to create a temporary table through a sql with out having to
> issue
> a drop command when done with it?
> Thanks in advance.
> --
> Deryl Banuelos
> BANU_at_Chevron.com
Received on Thu Mar 12 1998 - 00:00:00 CST