Re: Temporary tables inside procedure

On 7/28/06, Powell, Mark D <mark.powell@xxxxxxx> 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

Other related posts: