Re: Oracle temporary tables?

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Mon, 27 Mar 2000 18:04:43 +0200
Message-ID: <8bo0sf$6tl$1@news.inet.tele.dk>

Why waste time creating the tables every time you need them as you do with SQL Server and Sybase? In my opinion, Oracle's solution is better. There's two types of temporary tables in Oracle8i: Data is removed when the transaction or session ends.

You would use an INSERT INTO TEMPORARY_TABLE_1 SELECT ... ; construction to fill data into your temporary tables.

HTH. Finn

David Spaisman <davedba_at_intercall.net> wrote in message news:38DEBB89.F959E1B2_at_intercall.net...
> Hello:
>
> I just noted that Oracle 8.1.5 has provided for temporary tables. It did
> some research and found it that the tables are permanaent but the data
> is transient -- create global temporary table...
>
> In Sql Server, I have used true temporary tables (#Table_name)that are
> deleted when the stored procedure is
> finished running. By using temporary tables under mssql, I have been
> able to break down complex sql code(multiple table joinss) as
> individual table selects into a temporary table.
>
> I don't understand how create global tables can be used in a similar
> fashion.
>
> 1) Can it be?
>
> 2) Are there any other facilities in Oracle(other than create table as
> select ...) to accommodate temporary tables?
>
> Any information you can provide will be greatly appreciated. Thanks.
>
> David Spaisman
>
>
>
Received on Mon Mar 27 2000 - 10:04:43 CST