SQL TO_NUMBER Function
SQL TO_NUMBER function is used to convert any numeric value into number format. This function is mostly used when you need to perform some numeric function on columns with numeric values but stored under some other data types. The input string must consists of numbers, no other character is acceptable as input.
The syntax is:
TO_NUMBER (input string)
Example:
The following SQL TO_NUMBER Function will convert emp_id of all employees into number format
SELECT TO_NUMBER (emp_id) FROM employee;
Output:
