Term: PLS_INTEGER

Definition:
In Oracle PL/SL, PLS_INTEGER is a PL/SQL data type which belongs to the NUMBER family and used for storing signed integers. Since it uses machine arithmetic, it is usually faster in operations as compared to NUMBER data type. It value ranges from -2,147,483,647 to 2,147,483,647.

Note that because it is a PL/SQL type, it cannot be used in SQL.

Example Syntax:

DECLARE

VARIABLE PLS_INTEGER

DECLARE

L_NUM PLS_INTEGER;

BEGIN

L_NUM := 10;

END;

• Oracle Datatypes: PLS_INTEGER
• Array Processing: Example using PLS_INTEGER
• Control Structures: Example using PLS_INTEGER
• Contitions: Example using PLS_INTEGER
• DECODE CASE: Example using PLS_INTEGER
• Numeric Functions: Examples using PLS_INTEGER
• String Functions: Examples using PLS_INTEGER