Re: Temporary tables inside procedure

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 31 Jul 2006 12:06:45 -0700
Message-ID: <bf46380607311206n4995443la9ae1b4dda29bcc2@mail.gmail.com>

On 7/28/06, Powell, Mark D <mark.powell_at_eds.com> wrote:
>
>
> 2- you usually do not need temporary tables in Oracle. Many times
> #tables are used in SQL Server just because of how poorly it handles
> joins of 5 - 10 tables. In Oracle just do the join. Alternate features
> that can sometime replace a temporary table include reference cursors,
> piped row functions, and pl/sql collection structures.

And due to SQL Server allowing dirty reads.

As Mark stated, there's usually no need for temp tables in Oracle.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 31 2006 - 14:06:45 CDT