Oracle PL/SQL Tutorial/Numerical Math Functions/to binary double

Материал из SQL эксперт
Перейти к: навигация, поиск

v_double_nr:= to_binary_double(numeric variable)

   <source lang="sql">

SQL> SQL> set timing on SQL> SQL> declare

 2      v_nr number;
 3  begin
 4      for i in 1..1000000 loop
 5          v_nr:=sqrt(i);
 6      end loop;
 7  end;
 8  /

PL/SQL procedure successfully completed. Elapsed: 00:00:01.54 SQL> SQL> declare

 2      v_nr binary_float;
 3  begin
 4      for i in 1..1000000 loop
 5          v_nr:=sqrt(to_binary_float(i));
 6      end loop;
 7  end;
 8  /

PL/SQL procedure successfully completed. Elapsed: 00:00:00.51 SQL> SQL> set timing off SQL></source>