Monday 21 August 2006

Oracle tip: Bulk binding exceptions

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.



Tuesday 15 August 2006

Oracle tip: Oracle's online documentation

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.



Tuesday 8 August 2006

Oracle tip: 10gR2 regular expressions

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.