Home » SQL & PL/SQL » SQL & PL/SQL » What is Global Temporary Table? (Oracle 9i)
What is Global Temporary Table? [message #301624] Thu, 21 February 2008 03:27 Go to next message
Messages: 269
Registered: September 2007
Senior Member

What is Global Temporary Table?

I created through

Create gloabl temporary table
table1(column1 number,column2 number);

then i closed the session also..

i reopen the sql plus...

But still that table is there.

then why we should call Temporary table?


Re: What is Global Temporary Table? [message #301627 is a reply to message #301624] Thu, 21 February 2008 03:30 Go to previous message
Michel Cadot
Messages: 65140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The table is there but the data is not.
This is the meaning of "global".
You create the definition of the table, this is the permanent part.
You fill it during your session and the data disappear with it (or the transaction depending on the option you give).

Database Concepts
Chapter 5 Schema Objects
Section Temporary Tables

Previous Topic: deleting rows from master and child
Next Topic: Can I replace the column position?
Goto Forum:

Current Time: Fri Aug 18 03:58:36 CDT 2017

Total time taken to generate the page: 0.10805 seconds