Home » SQL & PL/SQL » SQL & PL/SQL » Global temporary table (10g, XP)
Global temporary table [message #401706] Wed, 06 May 2009 03:58 Go to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Hello all Gurus,

Actually I want to know about TEMPORARY TABLE.
For that I googled, but didn't find any useful link.
Please provide useful links.

regards,
Delna
Re: Global temporary table [message #401707 is a reply to message #401706] Wed, 06 May 2009 03:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Define "useful link".
I think Oracle documentation is useful but maybe not for you.

Regards
Michel
Re: Global temporary table [message #401709 is a reply to message #401706] Wed, 06 May 2009 04:02 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you're looking for details of Oracle features, then the Oracle Documentation is almost always the best place to start.
Re: Global temporary table [message #401710 is a reply to message #401707] Wed, 06 May 2009 04:07 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Thnak you JRowbottom sir for helping me.

Quote:
I think Oracle documentation is useful but maybe not for you.



WHY?

regards,
Delna
Re: Global temporary table [message #401715 is a reply to message #401710] Wed, 06 May 2009 04:27 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
WHY?


Because you never told us what actually would be useful to you.

The documentation would have been in the Google results somewhere, and you told us they are not useful for you. Why, we have no idea.
Re: Global temporary table [message #401716 is a reply to message #401706] Wed, 06 May 2009 04:27 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
The data in a global temporary table is private, such that data inserted by a session can only be accessed by that session. The session-specific rows in a global temporary table can be preserved for the whole session, or just for the current transaction. The ON COMMIT DELETE ROWS clause indicates that the data should be deleted at the end of the transaction.
CREATE GLOBAL TEMPORARY TABLE my_temp_table (
  column1  NUMBER,
  column2  NUMBER
) ON COMMIT DELETE ROWS;

In contrast, the ON COMMIT PRESERVE ROWS clause indicates that rows should be preserved until the end of the session.
CREATE GLOBAL TEMPORARY TABLE my_temp_table (
  column1  NUMBER,
  column2  NUMBER
) ON COMMIT PRESERVE ROWS;


Thanks,

[Updated on: Wed, 06 May 2009 04:33] by Moderator

Report message to a moderator

Re: Global temporary table [message #401717 is a reply to message #401710] Wed, 06 May 2009 04:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
delna.sexy wrote on Wed, 06 May 2009 11:07
...
Quote:
I think Oracle documentation is useful but maybe not for you.

WHY?
regards,
Delna

Because it is so obvious for me to first search into it and that if you "googled, but didn't find any useful link" it means for me that Oracle documentation (that you should have found googling) falls in the not useful category.

Regards
Michel

[Updated on: Wed, 06 May 2009 04:30]

Report message to a moderator

Re: Global temporary table [message #401722 is a reply to message #401716] Wed, 06 May 2009 04:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ora_2007 wrote on Wed, 06 May 2009 11:27
Blablabla

Does your post answer the question in anyway:
Quote:
Please provide useful links.

Please carefully read the question before posting irrelevant stuff.

Regards
Michel

Re: Global temporary table [message #401745 is a reply to message #401722] Wed, 06 May 2009 06:00 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Thnaks for all reply.

@Michel Cadot,
It is possible that link of oracle documentation comes after some pages in google search.
Or may be skiped by mistake.

regards,
Delna
Re: Global temporary table [message #401756 is a reply to message #401745] Wed, 06 May 2009 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
delna.sexy wrote on Wed, 06 May 2009 13:00
@Michel Cadot,
It is possible that link of oracle documentation comes after some pages in google search.
Or may be skiped by mistake.

So a good link to FIRST search for a question about Oracle:
http://otn.oracle.com/pls/db102/db102.federated_search

Regards
Michel

[Updated on: Wed, 06 May 2009 06:22]

Report message to a moderator

Re: Global temporary table [message #401910 is a reply to message #401756] Wed, 06 May 2009 23:26 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Ok, Thanks all once again

regards,
Delna
Re: Global temporary table [message #402349 is a reply to message #401910] Sat, 09 May 2009 01:01 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8635
Registered: November 2002
Location: California, USA
Senior Member
It can help to know where to search and how to search. Whenever searching for something about Oracle, I usually start with the online documentation, using the following menu:

http://www.oracle.com/pls/db111/homepage

If I don't find what I want there, then I go to Tom Kyte's site and search there:

http://asktom.oracle.com/pls/asktom/f?p=100:1:3354659615428059

If I still don't find what I want, then I resort to Google, but I add the word "Oracle" to whatever I am searching for, so that I don't have to sift through results related to other languages or even non-computer stuff. If you just Google for "temporary table", you might end up finding folding t.v. trays.

Whichever way I am searching, I look at whatever results I get, then decide if I need to broaden or narrow my search and try again until I find what I want.

ORAFaq also has search menus for the forums, the wiki, and the entire site. Oracle's OTN site has similar menus.

Re: Global temporary table [message #402363 is a reply to message #402349] Sat, 09 May 2009 05:49 Go to previous message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Great Barbara mam giving gentle reply!!!

regards,
Delna
Previous Topic: Convert string to time of day
Next Topic: close and re-open cursor for every 20 records
Goto Forum:
  


Current Time: Thu Dec 08 14:45:06 CST 2016

Total time taken to generate the page: 0.10939 seconds