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

Popular Posts:

Difference Between G...

What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...

CREATE TABLE - Creat...

How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...

AND, OR, XOR, and NO...

What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...

MySQL Database Tutor...

Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...

What Is SQL in MySQL...

What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Rela...