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