Oracle 10g's Finest – The Top 3 SQL and PL/SQL Features new in 10g – paper for ODTUG 2005

Papers for the ODTUG 2005 conference are limited to 10 pages. That is not enough. It never is, by the way. This time, I restricted myself to only three topics. However, each of these warranted these 10 pages. So, once again, I will probably not qualify for the Editor’s Choice award if only because of the length of the paper. Well, you may be interested all the same. So here it is:

Oracle 10g does not have an abundance of new SQL and PL/SQL features compared to 9iR2. In that sense you could view 10.0.1 more like a 9.3 release. Or at least, that was my first impression when I started using 10g in June 2004. Ever since, I have discovered a number of new functions and features that can really be useful. In hindsight, I could have written this paper on useful 10g stuff for SQL and PL/SQL developers about quite a few topics. I have selected three that really stand out: SQL’s Model Clause for post-processing the query result set in a spreadsheet-like manner, the DBMS_FREQUENT_ITEMSET supplied package for SQL and PL/SQL-based data mining, and expression filters as a mechanism to record sets of search criteria and use these very efficiently in SQL queries. I will give a brief introduction to each of these features, including examples that should help you get going yourself.

Download this paper ‘Oracle 10g’s Finest – The Top 3 SQL and PL/SQL Features new in 10g’