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: Lewis Cunningham,ADP-GMBH