BINARY_INTEGER in action : BINARY_INTEGER DOUBLE FLOAT « PL SQL Data Types « Oracle PL/SQL Tutorial






Both of these datatypes exist only in PL/SQL, and you cannot create a column of these types.

SQL>
SQL> declare
  2      variable1_nr BINARY_INTEGER;
  3      variable2_nr PLS_INTEGER;
  4  begin
  5     NULL;
  6
  7  end;
  8  /

PL/SQL procedure successfully completed.

SQL>
SQL> --
SQL>








21.33.BINARY_INTEGER DOUBLE FLOAT
21.33.1.BINARY_INTEGER
21.33.2.BINARY_INTEGER Subtypes
21.33.3.BINARY_INTEGER in action
21.33.4.NUMBER and BINARY_INTEGER Data types
21.33.5.Using BINARY_FLOAT and BINARY_DOUBLE for complex calculations