Numeric Data Type Conversion Chart
Alternative SQL Data type Oracle Equivalent Data type
NUMERIC ( PRECISION, SCALE ) NUMBER ( PRECISION, SCALE )
DECIMAL ( PRECISION, SCALE ) NUMBER ( PRECISION, SCALE )
INTEGER NUMBER ( 38 )
INT NUMBER ( 38 )
SMALLINT NUMBER ( 38 )
FLOAT(b) NUMBER
DOUBLE PRECISION NUMBER
REAL NUMBER
Related examples in the same category