Re: Orcale Temporary Tables

From: Tony Noble <cz0763%zip02_at_mt.gov>
Date: 1995/08/03
Message-ID: <3vr36l$9tc_at_umt.umt.edu>#1/1


In article <3vij0l$b11_at_homer.alpha.net>, sahmad_at_mfa.com says...
>
>
>What is a good way to create temporary tables in Oracle?
>
>I need to store data in a table temporarily to assist in
>reporting some stats.
>
>
>--
>**************************************************************
>* Saad Ahmad *
>* E-Mail: sahmad_at_mfa.com *
>**************************************************************
>

You may want to look into PL/SQL tables. These should work well for smaller amounts of data and they are fast since they are cached in the SGA. See the 'PL/SQL User's Guide and Reference' for more information.

TN
cz0763%zip02_at_mt.gov Received on Thu Aug 03 1995 - 00:00:00 CEST

Original text of this message