2 Replies Latest reply: May 30, 2007 3:20 AM by Muthukumar S RSS

    convert string(varchar) to number

    528400
      Hi ,

      How can we convert any varchar2 value to number.

      e.g. validity column is of varchar2 type and contains records like 002, 01, 1 -999,-111 etc

      I have to convert this into numbers and make some calculations.

      Thanks,

      Amitesh