Re: Newbie question

From: Rod Stewart <rod.stewart_at_afp.gov.au>
Date: Mon, 13 Sep 1999 14:06:25 +1000
Message-ID: <7rhtf8$2hu$1@platinum.sge.net>

Oracle only has temporary tables in the way I suspect you mean under version 8.1.5 and upwards (I think, I could be wrong!). Another way you could do it would be to use a 'virtual' table within a PL/SQL procedure or function.

HTH Rod J. Stewart

Alex Daman <alex_damanakis_at_exe.com.au> wrote in message news:xe_C3.13019$1E2.90490_at_ozemail.com.au...
> 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 Sun Sep 12 1999 - 23:06:25 CDT