oracle plsql（一）_binary_float_binary_double

plsql的資料型別，用於複雜的科學計算,32bit大小

 

SQL> r
  1  declare
  2  v_pls_integer pls_integer:=-100042578;
  3  begin
  4  dbms_output.put_line(to_char(v_pls_integer));
  5* end;
-100042578

PL/SQL procedure successfully completed.

.

SQL> declare
  2  v_binary_float binary_float:=-3548.25;
  3  begin
  4  dbms_output.put_line(to_char(v_binary_float));
  5  end;
  6  /
-3.54825E+003

PL/SQL procedure successfully completed.