Monday, 21 August 2006

Oracle tip: Bulk binding exceptions

Our Oracle tip of the week, published at

Handle bulk binding exceptions in PL/SQL

The downside to bulk binding in PL/SQL is that if any of the data values result in an invalid UPDATE, the entire set of iterations is rolled back. Bob Watkins explains how you can get around this issue.

Tuesday, 15 August 2006

Oracle tip: Oracle's online documentation

Our Oracle tip of the week, published at

Navigating Oracle's public online documentation

Here's a quick guide to navigating Oracle's public online documentation library, which contains hundreds of books. Bob Watkins also offers a rundown of his favorite offerings in the collection.

Tuesday, 8 August 2006

Oracle tip: 10gR2 regular expressions

Our Oracle tip of the week, published at

Search text with new Perl-like regular expressions in Oracle 10gR2

Oracle 10g Release 2 contains new Perl-like regular expressions. If you're developing scripts against Oracle 10gR2, check out these nifty shortcuts for searching text.