BINARY_FLOAT and BINARY_DOUBLE example : Binary Data Type « Data Type « Oracle PL / SQL

1. Oracle PL / SQL
2. Data Type
3. Binary Data Type

BINARY_FLOAT and BINARY_DOUBLE example

 

SQL> CREATE TABLE binary_test (
  2    bin_float BINARY_FLOAT,
  3    bin_double BINARY_DOUBLE
  4  );

Table created.

SQL>
SQL> INSERT INTO binary_test (
  2    bin_float, bin_double
  3  ) VALUES (
  4    39.5f, 15.7d
  5  );

1 row created.

SQL>
SQL> INSERT INTO binary_test (
  2    bin_float, bin_double
  3  ) VALUES (
  4    BINARY_FLOAT_INFINITY, BINARY_DOUBLE_INFINITY
  5  );

1 row created.

SQL>
SQL> drop table binary_test;

Table dropped.

   
  

Related examples in the same category