PL/SQL Tip of the Month

From: Cam White <camwhite_at_earthlink.net>
Date: Sun, 15 Apr 2001 23:19:41 GMT
Message-ID: <h0qC6.3914$tv1.237376@newsread1.prod.itd.earthlink.net>

Improving Performance with FORALL

Compliments of Jeff Thomas (jsthomas_at_ixl.com)

I was recently experimenting with an Oracle 8.1.6 feature called "Bulk Binding", and was amazed at the performance gain. Any developer who is not aware of this capability is really missing out. I packaged my little test, and here is the result. Of course, your results will vary, but the point should be clear enough. The script and the output are shown for both the normal PL/SQL method and the FORALL method.

Scripts and Examples are posted on the PL/SQL Pipeline: http://www.revealnet.com/Pipelines/PLSQL/index.htm

Best wishes,

Cam White
RevealNet

---

---

Formatter Plus Now Available
Format, Code Review and Syntax-Check Entire PL/SQL Applications http://www.revealnet.com/Products/Formatter_Plus/formatter_plus.htm Received on Sun Apr 15 2001 - 18:19:41 CDT