BINARY_INTEGER Subtypes : BINARY_INTEGER DOUBLE FLOAT « PL SQL Data Types « Oracle PL/SQL Tutorial






SubtypeUsage
POSITIVEAllows only positive integers to be stored, up to the maximum of 2,147,483,647. Zero is not considered a positive number, and so is not an allowed value.
NATURALAllows only natural numbers to be stored, which includes zero. Allowed values are 0, 1, 2, 3, and so on up to the maximum of 2,147,483,647.
POSITIVEnLike POSITIVE but cannot be null.
NATURALnLike NATURAL but cannot be null.
SIGNTYPERestricts a variable to only the values -1, 0, and 1.


21.33.BINARY_INTEGER DOUBLE FLOAT
21.33.1.BINARY_INTEGER
21.33.2.BINARY_INTEGER Subtypes
21.33.3.BINARY_INTEGER in action
21.33.4.NUMBER and BINARY_INTEGER Data types
21.33.5.Using BINARY_FLOAT and BINARY_DOUBLE for complex calculations