view counter


Oracle PL/SQL (Procedural Language/Structured Query Language) resources, news, and support articles.

Collaborate 2012 – Day 3

Virtualization is important and Dave Welch from the House of Brick gave a great presentation of experiences with VMWare and Tier 1 databases. It was a comprehensive presentation, but the white paper was easier to follow. The slides were complete but the volume of information was a lot for an hour presentation. Well worth the time though.

Collaboration 2012 – Day 2

It seems the Titanic is everywhere, even inside the pyramid of the Luxor hotel. While the Luxor is within the Mandalay Bay complex, it’s about a half mile walk to the conference and a half mile back. We go by the Mandalay Conference Center’s aquarium.

Collaborate 2012 – Day 1

Collaborate 2012 started on Sunday but for me I began on Monday. I enjoyed Bob Burgess, SalesForce, presentation on shell scripting for MySQL Administration today.

Upgrade to Version 2.2 Complete

We have completed the upgrade of the PL/SQL Challenge to version 2.2. The main features of this release are:

Activity Points

Top selling items

A classic task given to a programmer is to make a TOP-N report of some data. Often a TOP within each group of some defined grouping (department, country, product type, etc.) And many times the report should also include the percentage of the total - even though you only display the TOP records.Many ways can be devised for this and many ways has been used and blogged about and given lectures on. This is nothing new, but it is a technique we often use in many practical cases. One typical case is a top list of best selling items within product groups.

Oracle Within Group

Somebody asked me for a useful example of Oracle 11gR2′s new analytical LISTAGG function that uses a WITHIN GROUP syntax. They’d noticed an update to the askTom that showed how to use it. This post shows how to list values without a displayed aggregation column and how to use a JOIN and GROUP BY clause with the new analytical feature.

Final beta test for PL/SQL Challenge 2.2

Dear players,

I invite (no, rather, I implore) you to visit and help us do a final round of testing for release 2.2 of the PL/SQL Challenge website. We've added many new features that will help you get more out of our growing repository of quizzes and resources.

Q1 2011 Ends, Time for Next Playoff


Q1 2011 ended on Friday, as far as the daily quizzes are concerned. Which means it is time to prepare for the championship playoff for that quarter. And a congratulations to the hundreds of players who committed a substantial amount of time playing quizzes, learning about PL/SQL, SQL and APEX, and in many cases sharing their knowledge with others through our discussion.

view counter