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