alex, if you use 8i there is temp table option. check it out at thomas
kyte's web site for detailed description.
Ted Chyn
In article <_e_C3.13020$1E2.90917_at_ozemail.com.au>,
"Alex Daman" <alex_damanakis_at_exe.com.au> 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
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Sep 13 1999 - 12:41:55 CDT
