| What is Global Temporary Table? [message #301624] |
Thu, 21 February 2008 03:27  |
spmano1983
Messages: 269
Registered: September 2007
|
Senior Member |
|
|
Frinds,
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?
Thanks
Mano
|
|
|
|
| Re: What is Global Temporary Table? [message #301627 is a reply to message #301624] |
Thu, 21 February 2008 03:30  |
 |
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
