>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.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')
Tom> Oh, thanks ... I was wondering what locale it had chosen, but did
Tom> not know how to find out.
I had to ask around to find a way that worked both on rextester.com and
on sqlfiddle.com (which also supports Oracle 11, and is where I usually
test oracle query compatibility things). It was the fact that the two
sites behaved differently for this query that got me looking at
parameter settings to begin with; sqlfiddle defaults to US locale.
--
Andrew (irc:RhodiumToad)