expr to a value of
NUMBER data type. The
expr can be a
BINARY_DOUBLE value or a value of
NVARCHAR2 data type containing a number in the format specified by the optional format model
You can specify an
BINARY_FLOAT. However, it makes no sense to do so because a float can be interpreted only by its internal presentation.
Refer to "Format Models" for information on number formats.
'nlsparam' argument in this function has the same purpose as it does in the
TO_CHAR function for number conversions. Refer to TO_CHAR (number) for more information.
This function does not support
CLOB data directly. However,
CLOBs can be passed in as arguments through implicit data conversion.
See Also:"Data Type Comparison Rules" for more information.
The following examples convert character string data into a number:
UPDATE employees SET salary = salary + TO_NUMBER('100.00', '9G999D99') WHERE last_name = 'Perkins';
SELECT TO_NUMBER('-AusDollars100','L9G999D99', ' NLS_NUMERIC_CHARACTERS = '',.'' NLS_CURRENCY = ''AusDollars'' ') "Amount" FROM DUAL; Amount ---------- -100