Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

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> --