In this tutorial we are going to cast varchar to number. See the below example.
Syntax:
Parameter should contain numbers only. Trailing spaces are allowed .
Syntax:
SELECT CAST('12' AS NUMBER) FROM DUAL;