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

The only way I know to do this is to use PL/SQL. There you can create a temporary table (using arrays).

Rachel

Mike Adams wrote:

> 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 Tue Mar 17 1998 - 00:00:00 CST