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

0 0
Read Time:1 Minute, 16 Second

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’

About Post Author

Lucas Jellema

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

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

Comments are closed.

Next Post

Customizing ORA, JBO and JHS error messages in JDeveloper with ADF

Recently I encountered the problem of overriding error messages in my project created in JDeveloper using ADF/JHeadstart. I wanted to get rid of messages containing codes like JHS-00106 and JBO-27014 and replace them with my own messages. The JHeadstart Developer’s Guide briefly mentions this in the chapter 5 section “Internationalization”. […]
%d bloggers like this: