PLS INTEGER

From Oracle FAQ
Jump to: navigation, search

PLS_INTEGER is a PL/SQL data type used for storing signed integers. PLS_INTEGER is defined in the STANDARD package as a subtype (or rather a synonym) of BINARY_INTEGER. Variables declared as PLS_INTEGER can be assigned values between -2**31 to 2**31-1 (-2,147,483,648 to 2,147,483,647).

PLS_INTEGER operations use machine arithmetic, so they are generally faster than NUMBER and INTEGER operations.

[edit] History

Prior to Oracle 10g PLS_INTEGER were faster than BINARY_INTEGER. However, starting from Oracle 10g, PLS_INTEGER and BINARY_INTEGER are identical and can be used interchangeably.

[edit] Examples

DECLARE
  TYPE my_array_t IS TABLE OF VARCHAR2(100) INDEX BY PLS_INTEGER;
  ...

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #