How to convert an Oracle string to a number?

1 year ago

Olivia Parker

1 minute

In Oracle database, you can use the TO_NUMBER function to convert a string into a number. The syntax is as follows:

TO_NUMBER(string, [format_mask], [nls_parameter])

Among them, the string is the string to be converted, the format_mask is an optional parameter used to specify the format of the string, and the nls_parameter is an optional parameter used to specify the format of numbers and dates.

Example:
“He is studying for his upcoming exam.”

“He is preparing for his upcoming exam.”

SELECT TO_NUMBER('12345') FROM dual;

This will convert the string ‘12345’ to the number 12345.