Oracle Temp table help

X-No-Archive: yes

I'm trying to learn how to create a temp table as well as to specify whether it's session or transaction scope.

I'm coming up empty in terms of finding a good web page that describes this process. The one's that I have found
want you to pay a monthly fee. The oracle concepts manual that I downloaded did not provide me with sufficient information.

Just want to see an example of how to create the 2 types of temp tables and how to play around with adding/deleting rows from it.

Also, in the past, I used to work with Informix. We were constantly creating/dropping temp tables on-the-fly. I heard that is not the best way in Oracle (and it is recommended against doing so). The only thing that's "slightly" disturbing about creating temp tables "and leaving their definition in the data dictionary on a permant basis" once rather than "on-the-fly" is that there could be alot of these definitions in the data dictionary if you have a system that requires many temp tables of different types (ie, like a scrubber/loader or a system with alot of staging data tables).

thanks again!!! Received on Mon Jul 26 2004 - 22:01:16 CDT