Quantcast
OracleBrains.Com header image 2

PL/SQL::New PL/SQL SIMPLE_INTEGER DATA TYPE

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.
    or
    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

    *
    To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
    Click to hear an audio file of the anti-spam word

    Comment moderation is enabled. Your comment may take some time to appear.