TO_NUMBER

Purpose

This function converts a string of the CHAR, VARCHAR2, NCHAR, NVARCHAR2, BINARY_FLOAT, or BINARY_DOUBLE data type to a value of the NUMBER data type.

Syntax

TO_NUMBER(expr [, fmt [, 'nlsparam' ] ])

Parameters

Return type

NUMBER

Examples

• Convert the string 0123456 to a number.

  obclient> SELECT TO_NUMBER('0123456') FROM DUAL;
  +----------------------+
  | TO_NUMBER('0123456') |
  +----------------------+
  |               123456 |
  +----------------------+
  1 row in set
  

• Convert the hexadecimal number 16f to a decimal number.

  obclient> SELECT TO_NUMBER('16f','xxx') FROM DUAL;
  +------------------------+
  | TO_NUMBER('16F','XXX') |
  +------------------------+
  |                    367 |
  +------------------------+
  1 row in set