Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about the advantages of the data types BINARY_FLOAT and BINARY_DOUBLE in Oracle 10g. The article is rich in content and analyzes and describes it from a professional point of view. I hope you can get something after reading this article.

Oracle 10g references two new data types: BINARY_FLOAT and BINARY_DOUBLE,BINARY_FLOAT and BINARY_DOUBLE, which complement the existing NUMBER types, and BINARY_FLOAT and BINARY_DOUBLE have the following advantages over NUMBER types:

1. Less storage space required BINARY_FLOAT and BINARY_DOUBLE require 5 bytes and 9 bytes of storage, respectively, while NUMBER may require up to 22 bytes of storage.

two。 A larger range of numbers can be represented. BINARY_FLOAT and BINARY_DOUBLE support larger or smaller numbers than those stored in the NUMBER type.

3. Faster to perform operations operations on data of type BINARY_FLOAT and BINARY_DOUBLE are generally faster than data of type NUMBER. This is because the operations of BINARY_FLOAT and BINARY_DOUBLE are performed in hardware, while NUMBER first uses software to convert before the operation.

4. Operation closure the mathematical operations performed on both BINARY_FLOAT and BINARY_DOUBLE are closed, which means that the result of the operation is either a number or a special value.

5. Rounding transparent BINARY_FLOAT and BINARY_DOUBLE uses binary (base 2) to represent numbers, while NUMBER uses decimal (base 10). Indicates that the cardinality used by the number has an impact on the rounding of the number.

It is also important to note that if you are developing a system that involves a large number of operations, you should consider using BINARY_FLOAT and BINARY_DOUBLE types to represent numbers.

These are the advantages of the data types BINARY_FLOAT and BINARY_DOUBLE in Oracle 10g shared by Xiaobian. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.