transform a varcha2 column to a number code example

Example: convert a varchar2 to number

SELECT TO_NUMBER(NVL(emp_salary,'0'),'9999D99','nls_numeric_characters=,.')
FROM emp_details