Subtype Usage
DECIMALSame as NUMBER
DECSame as DECIMAL
DOUBLE PRECISIONSame as NUMBER
NUMERICSame as NUMBER
REALSame as NUMBER
INTEGEREquivalent to NUMBER(38)
INTSame as INTEGER
SMALLINTSame as NUMBER(38)
FLOATSame as NUMBER
FLOAT(prec)Same as NUMBER(prec), but the precision is expressed in terms of binary bits, not decimal digits. Binary precision can range from 1 through 126.