Oracle 11g New features for Developers

1.       Virtual Columns

2.       Named Notation in SQL

BEGIN

   package_name.procedure_name( p_parameter1 => 'some value',

                                p_parameter2 => 'another_value' );

END;

3.       SIMPLE_INTEGER Data type
Technically speaking it's not really a data type, but rather a subtype of the data type pls_integer. The simple integer is defined to take advantage of hardware arithmetic rather than software arithmetic. When simple integer is combined with real native compilation, the performance will be significantly better.
 If you set the variable to NULL inside the program, such as:
num1 := NULL;
 you will get a compilation error:   PLS-00382: expression is of wrong type  
If your program expects to set a variable to null, you can't define that variable as simple_integer.

4.       REGEXP_COUNT

SELECT REGEXP_COUNT(JOB,'A') FROM EMP;

5.