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:
- 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.
- New Data Type: simple_integer. Always NOT NULL, wraps instead of overflows and is faster than PLS_INTEGER.
- 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.
- Compound triggers. The trigger that is a before, after, row and statement all in one and it maintains its statements between each.
- 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.
- 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.
- Support for SUPER references in Oracle Object Type methods.
- Read only tables
- Trigger order.Now can specify Trigger firing order.
- Triggers are faster in 11g.
- Continue statement is added.
- 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;
- Native compilation is possible without C compiler.
Source: ,
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