OracleBrains.Com header image 2


August 29th, 2007 by Rajender Singh · No Comments

Checked the New PL/SQL SIMPLE_INTEGER data type, found following facts about it:

  • SIMPLE_INTEGER is a predefined subtype of the PLS_INTEGER data type.
  • Same range as PLS_INTEGER (-2,147,483,648 through 2,147,483,647)
  • Does not include null value.
  • Has NOT NULL constraint so not checked for null value.
  • No overflow checked.
  • If value goes greater then 2,147,483,647 then it will became -2,147,483,648.
    If value decreases less then -2,147,483,648 then it will became 2,147,483,647.

    As a result without overhead of checking for nullness and overflow, SIMPLE_INTEGER provides significantly better performance than PLS_INTEGER because arithmetic operations on SIMPLE_INTEGER values are done directly in the hardware.

    Tags: Oracle 11g New Features · SQL and PL/SQL

    0 responses so far ↓

    • There are no comments yet...Kick things off by filling out the form below.

    Leave a Comment