>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
Tom> Tested at
Tom> http://rextester.com/l/oracle_online_compiler
The problem is that this tester is defaulting to a German locale and
using . as a thousands separator and , as decimal point, as shown by
this query:
select * from nls_session_parameters
where parameter in ('NLS_TERRITORY','NLS_NUMERIC_CHARACTERS')
If you do
ALTER SESSION SET NLS_TERRITORY = 'AMERICA' \\
SELECT to_number('123.0', 'FM9999999') FROM DUAL
then the result is, as expected,
ORA-01722: invalid number
--
Andrew (irc:RhodiumToad)