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

Popular Posts:

Windows Applications...

How Can Windows Applications Connect to Oracle Servers in Oracle? A Windows application can connect ...

RAND() - Generating ...

How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...

SQL Server Database ...

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

About dba.FYIcenter....

What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...

Define External Tabl...

How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...