• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Temporary Tables in Oracle

 
PavanPL KalyanK
Ranch Hand
Posts: 212
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 50171
79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think you would do well to Google for SQL temporary table.
 
PavanPL KalyanK
Ranch Hand
Posts: 212
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Anybody on this .
 
Steve James
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34965
378
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
PavanPL KalyanK
Ranch Hand
Posts: 212
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
(which I think it was), this is a valid response.



You people support each other nicely , which is required .Good
 
Campbell Ritchie
Sheriff
Pie
Posts: 50171
79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic