| 15. 8. 1. TO_NUMBER(x [, format]) converts x to a number. |
|
|
The TO_NUMBER function converts a character string of type CHAR or VARCHAR2 into a number. |
The Syntax for the TO_NUMBER Function |
TO_NUMBER(character_string, format, NLS_Params) |
After the format mask are several possible NLS parameters: |
- NLS_NUMERIC_CHARACTERS -- Specifies characters to use for group separators and the decimal point.
- NLS_CURRENCY -- Specifies the local currency.
- NLS_ISO_CURRENCY -- Character(s) to represent the ISO currency symbol.
|
You can provide an optional format string to indicate the format of x. |
| Parameter | Format Examples | | 9 | 999 | | 0 | 0999 9990 | | . | 999.99 | | , | 9,999 | | $ | $999 | | B | B9.99 | | C | C999 | | D | 9D99 | | EEEE | 9.99EEEE | | FM | FM90.9 | | G | 9G999 | | L | L999 | | MI | 999MI | | PR | 999PR | | RN rn | RN rn | | S | S999 999S | | TM | TM | | U | U999 | | V | 99V99 | | X | XXXX |
|
The following example converts the string 97.13 to a number using TO_NUMBER(): |
|
SQL>
SQL> SELECT TO_NUMBER('97.13') FROM dual;
TO_NUMBER('97.13')
------------------
97.13
SQL>
|
|