PLS_INTEGER : PLS_INTEGER « PL SQL Data Types « Oracle PL/SQL Tutorial






The PLS_INTEGER datatype is used for declaring signed integer variables.

The PLS_INTEGER datatype stores values in the range -2,147,483,647 through 2,147,483,647.

The PLS_INTEGER datatype uses the native machine instructions for performing computations.

PLS_INTEGER calculations are much faster than BINARY_INTEGER calculations.

The Syntax for the PLS_INTEGER Datatype

variable_name PLS_INTEGER;

Here is a sample declaration:

my_integer PLS_INTEGER;

Oracle recommends use of the PLS_INTEGER datatype over the BINARY_INTEGER datatype in all new applications.

21.19.PLS_INTEGER
21.19.1.PLS_INTEGER
21.19.2.PLS_INTEGER in action
21.19.3.Use PLS_INTEGER as the loop counter