For more information about the SQL TO_NUMBER function, see Oracle Database SQL Reference. The OLAP DML TO_NUMBER function has the same functionality as the SQL TO_NUMBER function. Refer to NLS Options for additional information. These parameters override the default values specified by th NLS_CURRENCY, NLS_ISO_CURRENCY, and NLS_NUMERIC_CHARACTERS options. dgĪ text expression composed of two different, single-byte characters for the decimal marker ( d) and thousands group marker ( g). territoryĪ text expression that identifies the territory whose ISO currency symbol is used. This expression contains one or more of the following parameters, separated by commas:Ī text expression that specifies the local currency symbol. nlsparamsĪ text expression that specifies the thousands group marker, decimal marker, and currency symbols used in text-exp. ) as the decimal marker and does not recognize any other symbol. The default number format identifies a period (. For information about number format models, see the Oracle Database SQL Reference and the Oracle Database Globalization Support Guide. This model specifies how the conversion to NUMBER should be performed. fmtĪ text expression that identifies a number format model.

A conversion from NTEXT can result in an incorrect result when the NTEXT value cannot be interpreted as a number. The expression can have the TEXT or NTEXT data type. TO_NUMBER( text-exp, )Ī text expression that contains a number to be converted. Negative return values contain a leading negative sign, and positive values contain a leading space, unless the format model contains the MI, S, or PR format elements. This function is typically used to convert the formatted numerical output of one application (which includes currency symbols, decimal markers, thousands group markers, and so forth) so that it can be used as input to another application. The TO_NUMBER function converts a formatted TEXT or NTEXT expression to a number.

Oracle convert string to number