Re: Is there any equivalent of Sql Server's temporary table in Oracle

From: damorgan <damorgan_at_exesolutions.com>
Date: Thu, 05 Dec 2002 20:19:39 GMT
Message-ID: <3DEFB4DA.E1501085@exesolutions.com>

gamaz wrote:

> Hi,
> In sql server, some of the stored procedures I handled using temporary
> tables. The idea was to make joins simplified specially when there are six
> to eight table joins involed in data extraction. Those can are broken up in
> steps using temporary tables. I was wondering, what would be equivalent
> concept to handle joins of six to eight tables to extract data in Oracle. I
> know it is possible do crude lengthy joins, but I am sure there would be an
> elegant way to handle the same. Any insight/advise/link to knowledge site is
> appreciated in advance.
> Regards

This is Oracle not a Microsoft product. Rather than bringing Oracle to its knees work with the architecture.

Just write your joins, forget about the temporary tables, and invest the time you would have otherwise wasted learning Oracle architeture and concepts.

Dan Morgan Received on Thu Dec 05 2002 - 14:19:39 CST