Re: Temporary tables in Oracle

I agree not having temp tables is a bummer.

But the solution proposed by above by flange is a good solution. This is useful for breaking up queries with many tables.

Also, if your in a procedure, try to use nested cursors to build a result set.

On Wed, 24 Sep 1997 08:38:55 -0400, Mahesh Patel <mpatel_at_dbna.com> wrote:

>I have Sybase and Informix experience and am trying to write a complex
>query in a Stored procedure. How do I create and use temporary tables
>in Oracle.
>
>Hard to believe but it seems that Oracle does not have temperory tables
>like Sybase and Informix have.
>
>Any help will be appreciated.
>
>
>- Mahesh
>mpatel_at_dbna.com
Received on Thu Sep 25 1997 - 00:00:00 CDT