Result grid sorts numbers as text, order by works as expected

[Anders Eklund]

Hi,

I have a problem in PL/SQL Developer 11.0.2.1766.
If i do this select and sort the value in the grid by using the sort button the value is sorted as text. (14.04 comes before 4.86 row 3 and 8)
If i use oracle order by the output is sorted correct.
Is there a setting for this or what am i doing wrong?

select sqrt(power(abs(x.val),2)+power(abs(x.val),2)) as Hyp
from (
SELECT dbms_random.value(1,10) as val
FROM DUAL
CONNECT BY ROWNUM <= 9) x
-- order by 1

 

[T-Gergely]

You must have "Number fields to_char" checked in Preferences/Window Types/SQL Window.

 

[Anders Eklund]

It is not checked, but i made some changes to Preferences/User Interface/NLS Options.
Under the Numbers tab if i have , (comma) as decimal seperator SQL window sorts the numbers correct, if i have it as . (dot) it sorts it as string sorting.

 

[T-Gergely]

Then it must be a bug not yet implemented in PSD version 7 that we use.