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