PL/SQL has subtypes of datatypes. This MEANS subtype is a subset of a datatype. The FOLLOWING are the types and subtypes of Numeric data TYPE in PL/SQL

• PLS_INTEGER

Signed INTEGER in range -2,147,483,648 through 2,147,483,647, represented in 32 bits

• BINARY_INTEGER

Signed integer in range -2,147,483,648 through 2,147,483,647, represented in 32 bits

• BINARY_FLOAT

Single-precision IEEE 754-format floating-point number

• BINARY_DOUBLE

Double-precision IEEE 754-format floating-point number

• DEC(prec, scale)

ANSI specific fixed-point type with maximum precision of 38 decimal digits

• DECIMAL(prec, scale)

IBM specific fixed-point type with maximum precision of 38 decimal digits

• NUMERIC(pre, secale)

Floating type with maximum precision of 38 decimal digits

• DOUBLE PRECISION

ANSI specific floating-point type with maximum precision of 126 binary digits (APPROXIMATELY 38 decimal digits)

• SMALLINT

ANSI and IBM specific integer type with maximum precision of 38 decimal digits

• REAL

Floating-point type with maximum precision of 63 binary digits (approximately 18 decimal digits)