PL/SQL (MOSC)

MOSC Banner

Ask about BULK COLLECT in 10.2

edited Jul 17, 2011 9:09PM in PL/SQL (MOSC) 1 commentAnswered
Hi all,

I read title about "Using BULK COLLECT with Queries" and there is short document said that:

As a result, you do not need to explicitly convert your cursor FOR loops to use BULK COLLECT if:

 + You are running 10.2 or higher.
 + Your optimization level is to 2 or higher.
 + The cursor FOR loop does not contain any DML statements (insert, update, delete).

So, I'm using 10.2. If I open a cursor and FOR loop not BULK COLLECT, this code 's perfomance is same as using the BULK COLLECT ???

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center