BINARY_FLOAT_INFINITY, BINARY_DOUBLE_INFINITY : Binary Data Type « Data Type « Oracle PL / SQL






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

BINARY_FLOAT_INFINITY, BINARY_DOUBLE_INFINITY

 

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

1.Use binary data type
2.BINARY_INTEGER assignment
3.BINARY_INTEGER as loop counter
4.BINARY_FLOAT and BINARY_DOUBLE example