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

On Thu, 05 Dec 2002, gamaz_at_eathlink.net 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

Let Oracle do the temporary set building. You code the join.

-- 
Galen Boyer