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

Term: INTEGER

Definition:
In Oracle, an INTEGER is an ANSI SQL data type which refers to numeric values which have only an integer portion and no floating point or decimal part. That is, an INTEGER will only store whole numbers, such as 5, 93, 1816. An INTEGER cannot store '12.85', or any number with a decimal component. If a number with a decimal component is stored as an INTEGER, Oracle will truncate the number. Storing '12.85' as an INTEGER will result in the number being stored aas '12'.

In Oracle, the INTEGER datatype is usually referred to as NUMBER(38). Its precision can range from 1 to 38.

Oracle 11g introduced SIMPLE_INTEGER, a subtype of BINARY_INTEGER. Its range is -2147483648 to 2147483648. The SIMPLE_INTEGER cannot store a NULL value.


Related Links:

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