October 9th, 2008
INTEGER Data
Posted by
admin in
F. Data Types
INTEGER is a data type that can contain a whole number in the range of -2,147,483,648 to +1,147,483,647.
INTEGER is the same as INT. We use INTEGER in this course.
Â
Example: COL1 INTEGER
COL1 can have a small to large integer value.
Â
Notice that the keyword, INTEGER, is a complete definition of the data type and has no value defined in parentheses. This is because INTEGER limits the values in the column to the range shown above.
For most DBMS systems, INTEGER is a 32-bit value.
