Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle temporary tables?
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.
Any information you can provide will be greatly appreciated. Thanks.
David Spaisman Received on Sun Mar 26 2000 - 16:37:07 CST