Re: Help with temporary tables

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Mon, 19 Apr 1999 08:46:35 +0100
Message-ID: <7feji1$ldm$1@news.inet.tele.dk>

Paul Wiles wrote in message <3718ba46_at_newsread3.dircon.co.uk>...
>How do I rewrite this query in Transact SQL so it will work on Oracle
>
>select * into #temptable from MAIN_TABLE.
>
>I can't find any documentation on the usage of temporary tables in Oracle.
>
>Thanks
>
>Paul
>
>
>
>

Temporary is a new feature of Oracle8i that was just released. I'm not aware how it's implemented but you could have a look in the documentation from Oracle Technology Network at http://technet.oracle.com/doc/server.815/ (you need to be a member but it's free).

Finn Received on Mon Apr 19 1999 - 02:46:35 CDT