Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Is there any equivalent of Sql Server's temporary table in Oracle

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

From: gamaz <gamaz_at_eathlink.net>
Date: Thu, 05 Dec 2002 17:12:38 GMT
Message-ID: <aOLH9.5825$hM3.653883@newsread2.prod.itd.earthlink.net>


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 Received on Thu Dec 05 2002 - 11:12:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US