OracleBrains.Com header image 2

Enhancements in Oracle 11g PL/SQL

December 15th, 2006 by Rajender Singh · 3 Comments

Today I came across one intersting topic called Enhancements in Oracle 11g PL/SQL.Some of the interesting features that I got are as follows:

  1. Fine Grained Depenancy Tracking (FGDT?). This means that when you add a column to a table, or a cursor to a package spec, you don’t invalidate objects that are dependant on them.
  2. New Data Type: simple_integer. Always NOT NULL, wraps instead of overflows and is faster than PLS_INTEGER.
  3. SQL and PL/SQL result caching. Now there is a result cache that can store actual results from queries and stored procedures. Later calls are almost instaneous.
  4. Compound triggers. The trigger that is a before, after, row and statement all in one and it maintains its statements between each.
  5. Dynamic SQL. DBMS_SQL is here to stay. It’s faster and is being enhanced. DBMS_SQL and NDS can now accept CLOBs (no more 32k limit on NDS). A ref cursor can become a DBMS_SQL cursor and vice versa. DBMS_SQL now supprts user defined types and bulk operations.
  6. FGAC for UTL_SMTP, UTL_TCP and UTL_HTTP. Fine grained access control to the TCP packages family (utl_tcp, utl_smtp, …). Now we can grant execute on the package only for specific IP addresses.You can define security on ports and URLs.
  7. Support for SUPER references in Oracle Object Type methods.
  8. Read only tables
  9. Trigger order.Now can specify Trigger firing order.
  10. Triggers are faster in 11g.
  11. Continue statement is added.
  12. Using sequence in PL/SQL without DML.A sequence’s nextval needs not anymore be selected from dual, it suffices to write: my_var := my_sequence.nextval;
  13. Native compilation is possible without C compiler.

Source: ,


Tags: Oracle 11g New Features · SQL and PL/SQL

3 responses so far ↓

  • 1 OracleBrains Oracle Community Webspace - Blog » Oracle 11g (Beta) New Features // Dec 17, 2006 at 2:57 pm

    [...] After what I find yesterday (Enhancements in Oracle 11g PL/SQL), I research more about Oracle 11g. Found out few more things about it. [...]

  • 2 OracleBrains.Com » Blog Archive » can we use sequence in plsql // Jan 2, 2007 at 9:04 pm

    [...] But in future version of Oracle, 11g or whatever next version, Oracle is planning to provide such feature refer my old blog entry Enhancements in Oracle 11g PL/SQL. [...]

  • 3 OracleBrains Oracle Community Webspace - Blog » Can we use sequence in plsql // Jan 2, 2007 at 9:16 pm

    [...] But in future version of Oracle, 11g or whatever next version, Oracle is planning to provide such feature refer my old blog entry Enhancements in Oracle 11g PL/SQL. [...]

Leave a Comment