view counter


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


Click the image for scripts

OOW 2012: My Schedule

This will be my third time attending Oracle Open World and I'm really looking forward to the event.It is very hard to make a schedule, there are so many good session available. I thought I'd share my schedule, it might inspire you for your own schedule (or makes it harder to make a choice) and I can look at my schedule without having to login to the schedule builder.

Best Birthday Persent Ever

I just celebrated my 54th birthday in Glenn, MI, in a rental out near Lake Michigan. Check out photos here.


Click the image for scripts

NOT EXISTS in Relational Algebra and QBQL

Many people criticize SQL for bloated and inconsistent syntax. However, one must admit that some of its features give Relational Algebra run for the money. Consider recent stack overflow question “Relational Algebra equivalent of SQL “NOT IN””

Query rewrite

Click the image for scripts

Packt Publishing reaches 1000 IT titles and celebrates with an open invitation

Birmingham-based IT publisher Packt Publishing is about to publish its 1000th title. Packt books are renowned among developers for being uniquely practical and focused. Packt books cover highly specific tools and technologies which IT professionals might not expect to see a high quality book on.

Default behaviour


Click the image for scripts

PL/SQL Challenge Adds New Feature: Favorites

We upgraded to version 2.4 today and it has a single new feature - requested by many players: Favorites.

You can now "tag" authors, players, quizzes, resources, features and more as Favorites. The home page will then show latest news about your favorites and - if you are receiving emails with quiz results - you will be notified via a daily email digest of this news as well.

You will now see "Add to Favorites" links on the Quiz Details page, a player's profile, and more. Just look for this widget:

view counter