BINARY_INTEGER assignment
SQL> SQL> DECLARE 2 v_BinInt BINARY_INTEGER; 3 BEGIN 4 v_BinInt := 2147483647; 5 v_BinInt := v_BinInt + 1 - 1; 6 END; 7 / DECLARE * ERROR at line 1: ORA-01426: numeric overflow ORA-06512: at line 5 SQL>
1. | Use binary data type | ||
2. | BINARY_INTEGER as loop counter | ||
3. | BINARY_FLOAT and BINARY_DOUBLE example | ||
4. | BINARY_FLOAT_INFINITY, BINARY_DOUBLE_INFINITY |