Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Oracle Request SQLWays

Oracle Data Types - NUMBER

Versions: Oracle 11g, 10g, 9i, 8i and 7.3

Oracle - NUMBER
Syntax NUMBER[(p[,s])]
Data Integer, decimal and floating-point numeric data
Parameters p is the maximum number of all digits (both sides of the decimal point), s is the maximum number of digits after the decimal point

NUMBER(p) or NUMBER(p,0) specify integers
NUMBER(p,s) specifies fixed-point number
NUMBER specifies floating-point number the maximum range and precision
Range 1 ⇐ p ⇐ 38, -84 ⇐ s ⇐ 127
Default p is 38, s is 0
Storage Size 1 to 22 bytes
Standards Oracle Extension

Oracle NUMBER - Equivalents in Other Databases

Related Data Types in Oracle

Data Types
Floating-point FLOAT(p) BINARY_FLOAT BINARY_DOUBLE

All Data Types


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Oracle Request SQLWays

sqlways/oracle/data-types/number.txt · Last modified: May 07, 2018, 03:15:30 PM (external edit)
 
© 1999-2022, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement