aspose file tools*
The moose likes JDBC and the fly likes Temporary Tables in Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Temporary Tables in Oracle" Watch "Temporary Tables in Oracle" New topic
Author

Temporary Tables in Oracle

PavanPL KalyanK
Ranch Hand

Joined: Feb 28, 2009
Posts: 212
Hello ,

sorry to post here and waste your time if it's not appropiate to post it here .

What is the use of Temporary Tables in Database .


Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 40027
    
  28
I think you would do well to Google for SQL temporary table.
PavanPL KalyanK
Ranch Hand

Joined: Feb 28, 2009
Posts: 212
Anybody on this .
Steve James
Ranch Hand

Joined: Apr 12, 2009
Posts: 44
Campbell Ritchie wrote:I think you would do well to Google for SQL temporary table.


Pavan ,

Temporary tables are useful in applications where a result set is to be buffered. To create temporary table we have to issue CREATE GLOBAL TEMPORARY clause.

Like for example in a Procedure where you would need a table to store the results

CREATE GLOBAL TEMPORARY TABLE test_temp
(col1 number,
col2 number)
ON COMMIT DELETE ROWS;
Table created.


I am just a brick in the wall of Java
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31052
    
162

Pavan,
Please be patient and wait 24 hours before assuming people aren't looking at your question. For many of us (in the US), your question was posted in the middle of the night. In my time zone - 2am for the original time and 3 hours later for the bump. Many people still haven't even had the opportunity to see the question yet!

Steve,
Welcome to JavaRanch! Thank you taking the time to write an elaborate answer. Not everyone has that much time. Sometimes, it's better to write a little than nothing. Campbell did this - he made sure Pavan knew this was a piece of information that is on the internet and Pavan could get a faster answer by searching than waiting for a reply. When done in a nice way (which I think it was), this is a valid response.

Jeanne
JDBC Forum Moderator


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
PavanPL KalyanK
Ranch Hand

Joined: Feb 28, 2009
Posts: 212
(which I think it was), this is a valid response.



You people support each other nicely , which is required .Good
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 40027
    
  28
Yes, and finding a tutorial which you like on the internet would have been a far more efficient way for you to learn about temporary tables than for us to write about them. I did actually search for tutorials before replying, but didn't find anything I liked.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Temporary Tables in Oracle