Re: Can a procedure contain only a SELECT statement?

From: John Hurley <>
Date: Tue, 23 Mar 2010 12:20:30 -0700 (PDT)
Message-ID: <>

On Mar 23, 8:49 am, Serge Rielau <> 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.

The basic mantra of scalable Oracle performance is to take advantage of the features provided and don't try to do stuff in a database agnostic/neutral manner.

Logically I guess some of those features kinda/sorta smell like temporary tables. That's the kind of thing that Thomas Gagne needs to take the time to learn about if he wants to harness the power of Oracle. The learning curve takes a while though and you need to throw out some of the preconceived ideas. Received on Tue Mar 23 2010 - 14:20:30 CDT

Original text of this message