Re: Can a procedure contain only a SELECT statement?
From: Mladen Gogala <no_at_email.here.invalid>
Date: Tue, 23 Mar 2010 21:10:56 +0000 (UTC)
Message-ID: <pan.2010.03.23.21.10.56_at_email.here.invalid>
On Tue, 23 Mar 2010 12:20:30 -0700, John Hurley wrote:
>
> That's stuff inside PLSQL or special proprietary extensions of SQL by
> Oracle for more processing power.
Date: Tue, 23 Mar 2010 21:10:56 +0000 (UTC)
Message-ID: <pan.2010.03.23.21.10.56_at_email.here.invalid>
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.
-- http://mgogala.byethost5.comReceived on Tue Mar 23 2010 - 16:10:56 CDT