Thursday, August 12, 2010

Oracle 11g new features

Here we will discuss abt 11g new features

1. Datatype SIMPLE_INTEGER
                                                     1.Better performance while doing arithmetic calculations.
                                                      2.Values (-2,147,483,648 through 2,147,483,647)
                                                      3. Can not be null.
                                                      4. If value goes less than lower limit the variable of SIMPLE_INTEGER will take the value of upper limit and vice versa.
                                                       5. Subtype of PLS_INTEGER
6. Never give numeric overflow error.
7. Give performance boost if code is compiled in native mode instead of interpreted mode.
8. session can be altered from back end :- alter session set plsql_code_type 'NATIVE/interpreted.









No comments:

Post a Comment