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_at_newsread1.prod.itd.earthlink.net>
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 Mon Apr 16 2001 - 01:19:41 CEST
Date: Sun, 15 Apr 2001 23:19:41 GMT
Message-ID: <h0qC6.3914$tv1.237376_at_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 Mon Apr 16 2001 - 01:19:41 CEST