Creating Temporary Tables in Oracle.

From: <sumanm_at_my-dejanews.com>
Date: Wed, 28 Oct 1998 23:22:30 GMT
Message-ID: <7188vl$osf$1@nnrp1.dejanews.com>

How do I create Temporary Tables in Oracle ? I know that SQL Server supports it.
Basically I need to create a temporary table which is a subset of another table, then I need to update some information in that temporary table, use it and drop it.

While I am using this temporary table, I do not want another user who has logged in using the same login id/pwd (as mine) to see it or to update it.

What are the different possible ways of achieving it ?

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Oct 28 1998 - 17:22:30 CST