Re: Can a procedure contain only a SELECT statement?

From: Mladen Gogala <>
Date: Tue, 23 Mar 2010 21:10:56 +0000 (UTC)
Message-ID: <>

On Tue, 23 Mar 2010 12:20:30 -0700, John Hurley wrote:
>> If Oracle programmers don't need local temp tables then what is BULK
>> COLLECT, FORALL and INDEX BY all about? They are everywhere!

> That's stuff inside PLSQL or special proprietary extensions of SQL by
> Oracle for more processing power.

Oh boy, those are local temp tables. You can even do them explicitly by using /*+ MATERIALIZE */ in a "WITH" clause. And you must admit that the local temporary tables can be rather handy when you need them.

Received on Tue Mar 23 2010 - 16:10:56 CDT

Original text of this message