Our Oracle tip of the week, published at Techrepublic.com:
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.
Our Oracle tip of the week, published at Techrepublic.com:
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.
Our Oracle tip of the week, published at TechRepublic.com:
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.
