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

"gamaz" <gamaz_at_eathlink.net> wrote in message news:aOLH9.5825$hM3.653883_at_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

Hi,
I think starting with the Oracle concepts manual will help. The link is

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76965/toc.htm

Needs free registration

Hope this helps,
Saikat

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG