User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle Data Types - BINARY_FLOAT
Versions: Oracle 11g and 10g
| Oracle - BINARY_FLOAT | |
|---|---|
| Syntax | BINARY_FLOAT |
| Data | 32-bit, single-precision floating-point number |
| Range | 3.40282E+38F to 1.17549E-38F |
| Special Values | Supports special values INF, -INF (Infinity) and NaN (Not a number) |
| Storage Size | 5 bytes |
| Version Differences | Oracle 10g - BINARY_FLOAT is added |
| Standards | Oracle Extension |
Oracle BINARY_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 | REAL |
Related Data Types in Oracle
| Data Types | |||
|---|---|---|---|
| Floating-point, fixed-point and integers | NUMBER | FLOAT | BINARY_DOUBLE |
All Data Types