oracleskill

Home WORLD WIDE ARTICLE Oracle 11g programming support new features...

Oracle 11g programming support new features...

PHP      
      Improved PHP driver for Oracle.     
            
      Compilers     
      Improved native Java & PL/SQL compilers.     
            
      Oracle 11g XML Enhancements     
      Oracle 11g will also support Content Repository API for Java Technology (JSR 170). Oracle 11g has XML "duality", meaning that you can also embed XML directives inside PL/SQL and embed PL/SQL inside XML code. Oracle 11g XML will also support schema-based document Type Definitions (DTD's), to describe internal structure of the XML document.
Scalable Java      
      The next scalable execution feature is automatic creation of "native" Java code, with just one parameter for each type with an "on/off" value. This apparently provides a 100% performance boost for pure Java code, and a 10%-30% boost for code containing SQL     
            
      Improved sequence management     
      A new features of Oracle 11g will bypass DML ( sequence.nextval ) and allow normal assignments on sequence values.     
            
      Intra-unit inlining     
      In C, you can write a macro that gets inlined when called. Now any stored procedure is eligible for inlining if Oracle thinks it will improve performance. No change to your code is required. Now you have no reason for not making everything a subroutine!