Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle temporary tables?

Oracle temporary tables?

From: David Spaisman <davedba_at_intercall.net>
Date: Sun, 26 Mar 2000 22:37:07 GMT
Message-ID: <38DEBB89.F959E1B2@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 Sun Mar 26 2000 - 16:37:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US