Re: Newbie question

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 13 Sep 1999 08:23:26 -0700
Message-ID: <37DD16EE.A612A2BE@us.oracle.com>

Alex

Look at the temporary tables available in 8i.

Pete

Alex Daman wrote:

> Hello All,
>
> I want to know if there is a way to select data into a temporary table.
>
> For example :
>
> select * from my_table
> into temp my_temp_table.
>
> The temporary table should only exist for the duration of the session. I
> know with other database products you can do the above. I suppose I am
> looking for the equivalent for Oracle.
>
> Thanks in advance,
>
> Alex

Received on Mon Sep 13 1999 - 10:23:26 CDT