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

Oracle database how to use BINARY_FLOAT and BINARY_DOUBLE, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

BINARY_ double column:

CREATE TABLE binary_test (

Bin_float BINARY_FLOAT

Bin_double BINARY_DOUBLE

);

Note: in the SQL directory, you will find a script called oracle_10g_example.sql, which creates the binary_ test table in store schema. The script can also execute INSERT statements, and you can run this script if you can access a database of Oracle 10g. The following statements add a row to the binary_test table

INISERT INTO binary_test (

Bin_float, bin_double

) VALUES (39.5fdl 15.7d

);

F and d are used to indicate whether a number is of type BINARY_FLOAT or BINARY_DOUBLE, respectively.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

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.