use to_number to convert char to number
SQL> SQL> select to_number( '15' ) 2 from dual 3 / TO_NUMBER('15') --------------- 15 1 row selected. SQL> SQL> SQL> --