NUMBER and BINARY_INTEGER Data types : BINARY_INTEGER DOUBLE FLOAT « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. BINARY_INTEGER DOUBLE FLOAT

SQL>
SQL> set timing on
SQL> declare
  2      v_nr number;
  3  begin
  4      for i in 1..1000000 loop
  5          v_nr:=v_nr+i-i+i*2-i*2;
  6      end loop;
  7      DBMS_OUTPUT.put_line(v_nr);
  8  end;
  9  /

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.93
SQL>
SQL> declare
  2      v_nr binary_integer;
  3  begin
  4      for i in 1..1000000 loop
  5          v_nr:=v_nr+i-i+i*2-i*2;
  6      end loop;
  7      DBMS_OUTPUT.put_line(v_nr);
  8  end;
  9  /

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.25
SQL>
SQL> set timing off