TO_NUMBER
Converts an expression to a value of NUMBER
type.
SQL syntax
TO_NUMBER (Expression[, Format])
Parameters
TO_NUMBER
has the parameters:
Parameter | Description |
---|---|
|
The expression to be converted, where the value can be of type |
|
If specified, the format is used to convert |
Description
You can use a number format model with the TO_NUMBER
function. For more information on number format models, see "Number Format Models".
Examples
Command> SELECT TO_NUMBER ('100.00', '999D99') FROM dual; < 100 > 1 row found. Command> SELECT TO_NUMBER ('1210.73', '9999.99') FROM dual; < 1210.73 > 1 row found.