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

Term: NUMBER

Definition:
Oracle provides the NUMBER data type to store integers (negative, positive, floating) of up to 38 digits of precision. The NUMBER data type can store numbers in the range of 1.0E-130 to 1.0E126.

Other data types falling under the NUMBER data type family are BINARY_INTEGER, PLS_INTEGER, DOUBLE_PRECISION, and FLOAT.

Example Syntax:

NUMBER(x,y)


where x and y denote the precision specification of the variable.

Note the following declarations:

L_NUM NUMBER carries precision up to 38 digits.
L_NUM NUMBER(20) carries precision up to 20 digits.
L_NUM NUMBER(10,4) carries precision up to 10 digits, where 4 digits can be placed after the decimal.

Example Usage:

DECLARE
L_NUM NUMBER;
BEGIN
...
END;



Related Links:

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