Oracle Virtualization and Cloud Consulting
view counter


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


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:

MySQL 5.0 migration bug

At present, you can’t use the MySQL Workbench migration tool to migrate MySQL 5.0 to MySQL 5.5, as documented in Bug 66861. The documentation of the mysql.proc table is also different from the physical definition in MySQL 5.0 release. I logged documentation Bug 66886 to get it fixed.

Truncate dangers

Click the image for scripts

September Update at the PL/SQL Challenge

[Find below the text of the September 2012 e-newsletter sent out to PL/SQL Challenge subscribers.]

Another summer gone...and a hot one it was. Let's just hope the ice in the
Arctic circle returns next year. In the meantime, eyes turn towards Oracle Open
World, the annual extravaganza of All Things Oracle (and that is an
awful lot of "things", compared to the old days).

view counter