Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL PLS_INTEGER Datatype      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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


Example Usage:

DECLARE
L_NUM PLS_INTEGER;
BEGIN
L_NUM := 10;
END;


Related Links:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 111 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?