Re: Newbie question.
From: Darren John Capper <darren.capper_at_preci-spark.co.uk>
Date: Mon, 13 Sep 1999 09:14:24 +0100
Message-ID: <37DCB260.622ED11A_at_preci-spark.co.uk>
Date: Mon, 13 Sep 1999 09:14:24 +0100
Message-ID: <37DCB260.622ED11A_at_preci-spark.co.uk>
Alex,
[Quoted] create table my_temp_table as
select * from my_table;
Regards,
Darren
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:14:24 CEST