oracleskill

Home WORLD WIDE ARTICLE Oracle 11g PL/SQL new features.

Oracle 11g PL/SQL new features.

      PL/SQL "continue" keyword      
      This will allow a C-Like continue in a loop, to bypass any "else" Boolean conditions. A nasty PL/SQL GOTO is no longer required to exit a Boolean within a loop.     
            
      Disabled state for PL/SQL     
      Another 11g new feature is a "disabled" state for PL/SQL (as opposed to "enabled" and "invalid" in dba_objects).     
            
      Easy PL/SQL compiling     
      Native Compilation no longer requires a C compiler to compile your PL/SQL. Your code goes directly to a shared library.

Improved PL/SQL stored procedure invalidation mechanism       
      A new 11g features will be fine grained dependency tracking, reducing the number of objects which become invalid as a result of DDL.     
            
      Scalable PL/SQL     
      The next scalable execution feature is automatic creation of "native" PL/SQL (and Java code), with just one parameter for each type with an "on/off" value. This apparently provides a 100% performance boost for pure PL/SQL code, and a 10%-30% performance boost for code containing SQL.     
            
      Enhanced PL/SQL warnings     
      The 11g PL/SQL compiler will issue a warning for a "when others" with no raise.     
            
      Stored Procedure named notation     
      Named notation is now supported when calling a stored procedure from SQL.     
      RELATE LINK :     
      Oracle 11g SQL new features
Oracle 11g programming support new features
Oracle 11g DBA new features
Oracle 11g High Availability & RAC new features
Oracle 11g OEM Enterprise Manager new features
Oracle 11g Performance tuning optimization new features
Oracle 11g security & auditing new features