Datatypes that are efficient than SQL datatypes NUMBER or INTEGER - Tuning PL/SQL Applications

Q.  Which datatypes are PL/SQL-only datatypes that are more efficient than the SQL datatypes NUMBER or INTEGER for integer arithmetic?
- Published on 19 Oct 15

a. PLS_INTEGER
b. BINARY_INTEGER
c. Both A & B
d. None of the above

ANSWER: Both A & B
 
The BINARY_INTEGER is used to store signed integers. They require less storage than the number values. Arithmetic operations work faster.
PLS_INTEGER have the same advantages as the BINARY_INTEGER.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)