oracle - 将字符串转换为十进制 Oracle 数据库

Question

我打算在 Oracle 数据库中将数据类型字符串转换为十进制，但出现此错误:

ORA-01722: número no válido 01722. 00000 - "invalid number" *Cause: The specified number was invalid. *Action: Specify a valid number

代码:

TO_NUMBER('5.0') AS numero

CAST('5.0' AS NUMBER) AS numero

Answer 1

select TO_NUMBER('5.0') from dual;

select NLS_NUMERIC_CHARACTERS
 from v$nls_parameters;

 --There must be '.' in value filed to run above query