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

Home -> Community -> Usenet -> c.d.o.misc -> BULK COLLECT and QUERY REWRITE

BULK COLLECT and QUERY REWRITE

From: chris <crsedgar_at_hotmail.com>
Date: 27 Oct 2006 00:19:37 -0700
Message-ID: <1161933577.348322.210820@i3g2000cwc.googlegroups.com> 





I understand that Oracle 10g will rewrite your CURSOR FOR LOOP
statements into a BULK COLLECT statement.



I am contemplating no longer explicitly writing the BULK COLLECT from
now on as it reduces the number of lines of code and greatly simplifies
code.



Can anyone see any serious flaws in this strategy?



Kind Regards


Chris
Received on Fri Oct 27 2006 - 02:19:37 CDT












Original text of this message













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