Recent content by Anders Eklund

  1. A

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

    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.
  2. A

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

    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...
Back
Top