Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is there any equivalent of Sql Server's temporary table in Oracle
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