Re: Newbie question.

[Quoted] No temporary tables in Oracle. You'll have to drop all unwanted tables later on.

In article <37DCB260.622ED11A_at_preci-spark.co.uk>,   Darren John Capper <darren.capper_at_preci-spark.co.uk> wrote:
> Alex,
>
> create table my_temp_table as
> select * from my_table;

> > 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.
> >

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Sep 13 1999 - 20:51:52 CEST