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

Popular Posts:

FLOOR, CEILING, ROUN...

How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...

Using SELECT Stateme...

Can SELECT Statements Be Used on Views in SQL Server? Select (query) statements can be used on views...

Conditional Statemen...

Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...

WHILE ... Loops in S...

How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...

CONTINUE to Next Loo...

How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...