Oracle PL/SQL/PL SQL/Char to Number

Converting a character to an integer value

   <source lang="sql">

SQL> SQL> -- Converting a character to an integer value. SQL> DECLARE

 2        myString VARCHAR2(20) := "1997";
 3        myNumber NUMBER ;
 4  BEGIN
 5        myNumber := TO_Number(myString,"9999");
 6        DBMS_OUTPUT.PUT_LINE("The converted number is: " || myNumber);
 7        DBMS_OUTPUT.PUT_LINE("The converted number plus 10 is: " || (myNumber+10));
 8  END;
 9  /

The converted number is: 1997 The converted number plus 10 is: 2007 PL/SQL procedure successfully completed. SQL> SQL>

      </source>