Creating Temporary Tables in Oracle

From: <sumanm_at_my-dejanews.com>
Date: Wed, 28 Oct 1998 23:17:06 GMT
Message-ID: <7188li$ogo$1@nnrp1.dejanews.com>

How can I create temporary tables in Oracle ? I know that SQL Server supports temporary tables. Basically, I need to create a temporary table containing a subset of the data from another table. Then I want to update some rows in that temporary table, use it and later drop it.

I don't want anyone else who has logged on using the same userid/pwd to see my temporary table.

How do I achieve that ?

-----------== 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:17:06 CST