Temporary Tables in Oracle

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 .

I think you would do well to Google for SQL temporary table.

Anybody on this .

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.

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

(which I think it was), this is a valid response.

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

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.