Oracle - Differences between NUMBER and BINARY_FLOAT in Oracle

Differences between NUMBER and BINARY_FLOAT in Oracle

Q

What Are the Differences between NUMBER and BINARY_FLOAT in Oracle?

✍: FYIcenter.com

A

The main differences between NUMBER and BINARY_FLOAT are:

NUMBER stores values as fixed-point numbers using 1 to 22 bytes.
BINARY_FLOAT stores values as single precision floating-point numbers.

⇒Understanding SQL Language Basics for Oracle

⇒⇒Oracle Database Tutorials

2016-10-16, 524👍, 0💬

Popular Posts:

CONVERT() - Converti...

How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...

DYNAMIC - Creating D...

How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...

CONVERT() - Formatti...

How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...

Requirements for Usi...

What Do You Need to Connect PHP to MySQL in MySQL? If you want to access MySQL database server in yo...

AdventureWorksLT - D...

How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...