| 21. 19. 1. 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: |
|
|
Oracle recommends use of the PLS_INTEGER datatype over the BINARY_INTEGER datatype in all new applications. |