Oracle 11g Specifics

There is one thing I like about attending technical training. They fill you in on the latest change. For example, in my PL/SQL programming course I am hearing about features in Oracle database version 11g. We are still using Oracle 10g at work.

Here is an example of an Oracle 11g specific change. Previously you had to SELECT sequence NEXTVAL values FROM DUAL. But in 11g, NEXTVAL is a function. So you can assign its value directly to a variable.

Prior to Oracle 11g, you were able to place labels in your PL/SQL code but enclosing them like this <>. However in 11g, you put a BEGIN keyword before this label, and end the label section with the END keyword. Oracle 10g did not support this BEGIN and END to demarcate the block with the label.