v1_nr is a fixed-point number with 5-digit precision and positive scale of 2.

The code assigns a numeric literal to it with 3 digits before and after the decimal point.

v2_nr is a fixed-point number with 5-digit precision and negative scale of -2.

The code is assigning a numeric literal to it with 3 digits before and after the decimal point.

SQL> SQL> declare-- w w w . j a v a 2 s.co m 2 v1_nrNUMBER(5,2) := 123.567; 3 v2_nrNUMBER(5,-2) := 123.567; 4 begin 5 DBMS_OUTPUT.put_line(v1_nr||' and '||v2_nr); 6 end; 7 / 123.57 and 100 PL/SQL procedure successfully completed. SQL>

- NUMBER type
- Assigning a Fraction to an Integer
- NUMBER type without rounding
- BINARY_INTEGER Type
- BINARY_FLOAT and BINARY_DOUBLE
- Convert To BINARY_FLOAT and BINARY_DOUBLE