Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle Data Types - FLOAT

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

Oracle - FLOAT
Syntax FLOAT[(p)]
Data Floating-point numeric data
Parameters p is the binary precision. 126 digits of binary precision is roughly equivalent to 38 digits of decimal precision
Range 1 ⇐ p ⇐ 126
Default p is 126
Storage Size 1 to 22 bytes
Standards ANSI SQL

Oracle FLOAT - Equivalents in Other Databases

Database Data Type and Conversion
SQL Server FLOAT(p)
MySQL FLOAT(p,s)
PostgreSQL FLOAT(p)
Sybase ASE FLOAT(p)
Informix FLOAT(p), p is ignored
HP Neoview FLOAT(p)
Ingres FLOAT; REAL

Related Data Types in Oracle

Data Types
Floating-point, fixed-point and integers NUMBER BINARY_FLOAT BINARY_DOUBLE

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.