Re: Newbie question.

Not true. In Oracle8i, there are now temporary tables. I don't have a ref manual nearby to get the syntax, but they are now available.

Rick

igal_at_healthstreet.com wrote in message <7rjh41$2ec$1_at_nnrp1.deja.com>...
>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.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Tue Sep 14 1999 - 00:29:45 CEST