SQL>
SQL> DECLARE
2 v_Convert_Number VARCHAR2(20) := '1999';
3 v_Hold_Number NUMBER ;
4 BEGIN
5 v_Hold_Number := TO_Number(v_Convert_Number,'9999');
6 DBMS_OUTPUT.PUT_LINE('The converted number is: ' || v_Hold_Number);
7 DBMS_OUTPUT.PUT_LINE('The converted number plus 10 is: ' ||
8 (v_Hold_Number+10));
9 END;
10 /
The converted number is: 1999
The converted number plus 10 is: 2009
PL/SQL procedure successfully completed.
SQL>
SQL> --