Re: temp tables in oracle

From: Richard Armstrong <StateOArt_at_worldnet.att.net>
Date: Wed, 12 May 1999 10:46:47 -0600
Message-ID: <7hcb4v$cml$1@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 Wed May 12 1999 - 11:46:47 CDT