Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Catalogue of SQL and PL/SQL bad practices: Call for participation

Re: Catalogue of SQL and PL/SQL bad practices: Call for participation

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 20 Dec 2007 13:05:57 -0800
Message-ID: <1198184742.89306@bubbleator.drizzle.com>


Gojko Adzic wrote:
> HI Daniel,
>
> thanks. Could you be a bit more specific about the cursor loop?

Cursor loops have been obsolete in Oracle since the release of 9i. Any procedural processing should be based on bulk collecting into arrays using BULK COLLECT and then put back onto disk using FORALL.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Dec 20 2007 - 15:05:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US