TO_NUMBER

= NUMBER =

Description:
Number is an example of conversion. Which is used to store variable-length numeric data. Therefore no dashes, text, or other nonnumeric is allowed.

Examples:


SELECT TO_NUMBER('450') AS "Number Change" FROM DUAL;

 * Number Change ||
 * < 450 ||

SELECT TO_NUMBER('450','9999')+ 10 AS "Number Change"

 * Number Change ||
 * 460 ||

SELECT TO_NUMBER('23','99')

 * Number Change ||
 * 23 ||

**Explanation**:
This converts a nonnumeirc value such as "450" to a number, without the single quotes. The single qoutes are the characters.

**Other Information**:
There are moments when character string is converted to number.