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

From: Steve Johnson <robertoc_at_fyiowa.infi.net>
Date: 1998/03/17
Message-ID: <350E93EA.5C94@fyiowa.infi.net>#1/1

In Oracle the only way that I know of to create a temporary table is to use a SELECT statement in the FROM clause.

SELECT column1, column2
  FROM table1,

       (SELECT column2 
	  FROM table2) table2

 WHERE table1.somecolumn = table2.somecolumn;

Steve J

Rachel Carmichael wrote:
>
> 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