oracle query where varchar is as number code example

Example: oracle sql varchar to number

SELECT to_number('1') FROM DUAL;