15일차 # 2-18: BINARY_FLOAT & BINARY_DOUBLE type

* SQL & PL/SQL type

    - floating-point number literals

> 25f, +6.34F, 0.5d, -1D

      > binary_float_nan, binary_float_infinity

      > binary_double_nan, binary_double_infinity

    - the special values: INF, -INF, NaN

    - condition: is [not] nan

is [not] infinite

  * closed arithmetic operations 

  

select 100/0  from dual;    --> ORA-01476: divisor is equal to zero

select 100/0f from dual;    --> Inf

  * transparent rounding: rounding to the nearist binary

select 10/3 from dual;

select 10/3f from dual;

select 10d/3 from dual;

# 앞으로 수업 편의를 위해 p 프로시저 정의

create or replace procedure p (a varchar2)

is

begin

 dbms_output.put_line(a);

end;

/

show errors