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, 555👍, 0💬

Popular Posts:

CREATE, ALTER and DR...

Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...

AdventureWorksLT - D...

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

"ALTER TABLE ... ALT...

How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...

Creating a View with...

Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...

INSERT, UPDATE and D...

Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...