Oracle VM Consulting
view counter


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

SQL Developer tip: Don't open the table

One of things I don't like about Oracle SQL Developer is that if you are browsing and clicking on tables, it can automatically open the table on the right side of the IDE.There is a simple way to switch that off, just heard how to switch this feature off.

OOW 2012: Is PL/SQL still alive?

Yesterday Bryn Llewellyn, Distinguished Product Manager, did a session called "PL/SQL Enhancements brought by the latest generation of database technology". The room was packed. For the upcoming release of the Oracle 12c database the enhancements were broken into three areas:

  • Improved PL/SQL and SQL interoperability

    In the current version of the Oracle database you needed a Nested Table or Varray Type defined at schema level in order to be able to use it in the TABLE operator.

Should PL/SQL Developers Care About "Internals"?

We've posted a new Roundtable discussion with the title

Should PL/SQL Developers Care About "Internals"? 

This discussion point was provided Jeff Kemp, a long-time player of the PL/SQL Challenge who writes:

Just give it to me at random

Click the image for scripts

MySQL Workbench Book

Finally, I finished writing the MySQL Workbench book. It’ll be available next spring. Now it’s time to leave for the plane, fly to San Francisco, and see everyone at MySQL Connect.


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””

view counter