Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

NUMBER Subtypes

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.