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 Code Snippets: