Re: temp tables in oracle

Well, Oracle 8.1 finally introduces temporary tables in two flavors: Rows disappear after session is stopped or after transaction is ended.

HTH. Finn

Richard Armstrong <StateOArt_at_worldnet.att.net> wrote in message news:7hcb4v$cml$1_at_bgtnsc01.worldnet.att.net...
> create table x as select * from y;
> .
> .
> do your join;
> .
> .
> drop table x;
>
> You can also create indexes on your temp tables. Temp tables are a fact
of
> life, and quite useful for pruning large SQL statements into smaller bites
> so that they can run faster.
>
> At this time, there is no Sybase-like
> create-temp-table-in-memory-and-drop-on-disconnect in Oracle (thank
> goodness).
>
> --
> ****************************************
> Richard Armstrong
> State Of The Art Consulting, Inc.
> http://www.stateoart.com
> ****************************************
> alex menendez <amen_at_macromedia.com> wrote in message
> news:3738677C.2DC2357E_at_macromedia.com...
> > hello, all
> >
> > Is there anyway to create a temp table in oracle then select a number of
> > fields into it for a subsequent
> > join with another table?
> >
> > Most of my sql experience has been with sybase and I am new to oracle.
> > I know that in sybase you are able to create temp tables on the fly with
> > the #table_name notation.
> > These tables are kept in memory until the user logs out of his or her
> > sql session.
> >
> > Does such a thing exist in the oracle world?
> >
> > thanx in advance,
> > -amen
> >
>
>
Received on Thu May 13 1999 - 04:09:30 CDT