Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

PLS_INTEGER

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.