Re: Creating Temporary Tables in Oracle

From: Jim Lyons <j.lyons_at_cc.utexas.edu>
Date: Thu, 29 Oct 1998 10:50:19 -0600
Message-ID: <36389CCB.6D41@cc.utexas.edu>

sumanm_at_my-dejanews.com wrote:
>
> 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.

Would the use of PL/SQL tables help here?

--

Jim Lyons                     |  Operating Systems Specialist
ACITS                         |  512-475-9331

University of Texas at Austin | j.lyons_at_cc.utexas.edu http://uts.cc.utexas.edu/~jlyons Received on Thu Oct 29 1998 - 10:50:19 CST