|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
New features in Oracle 11g
The name of the 11 release is not (as of this writing) fixed, it could be 11g or, as some speculate, 11f (f standing for fusion) or even 10gR3.
The result_cache hint.
Possibility to specify the execution order of triggers.
Compound triggers: A trigger that is capable of doing before, after and statement in one.
In PL/SQL, a sequence's nextval needs not anymore be selected from dual, it suffices to write:
PL/SQL and inheritance: the
PL/SQL: ref cursors can be cast into a dbms_sql cursor and the be processed with the dbms_sql functions and procedures.
Fine grained dependency tracking: adding and dropping columns to/from a table does not invalide dependant views and packages (unless they are dependant on a dropped column of course).
Native compilation is possible without C compiler.
Intra-unit inlining: Apparently the same thing as declaring a method
FGAC also possible on UTL_SMTP, UTL_MAIL and UTL_HTTP.
Editions to have mutliple versions of triggers, views, synonyms etc in the database. It's not possible to have versions on tables, however, but there is the workspace manager to do that.