SQL Cookbook by Anthony Molinaro December 2005 $39.95 USD (Read Reviews)
You need to enable JavaScript to view more than 15 articles by this author.
Using the New MODEL Clause in Oracle Database 10g Publish Date: Aug. 11, 2004
One of the great new features of Oracle's flagship database software, Oracle Database 10g, is its new MODEL clause, which you can use in SELECT statements. In this article, Anthony Molinaro uses examples of the MODEL clause in action to show how you can move PL/SQL logic directly into SQL. This avoids the recursive calls and context switching that can result from calling PL/SQL in SQL, ultimately improving performance.
Buy 2 Books,Get the 3rd FREE! Use discount code "opc10" All orders over $29.95 qualify for free shipping within the US.