Mega Code Archive
Setting Precision and Scale
SQL>
SQL> declare
2 v1_nr NUMBER(5,2) := 123.567;
3 v2_nr NUMBER(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>