Sorting rows
To sort the rows in a result grid, press the heading button of the column on which you want the rows to be sorted.
The rows will be sorted in ascending order, as indicated by the heading button. Pressing the heading button again will sort the rows in descending order. Pressing it a 3rd time will undo the sorting. Pressing the heading button in another column will sort the rows on this column, but will also use the previous sort column as the secondary sort column (indicated by the dot in the heading button). In the example above, the job column is the primary sort column, and the hiredate column is the secondary sort column. By default the sort order will not be case sensitive. Right-click on the grid and select the Sort case sensitive item to change the sorting behavior.
Note that sorting is performed locally, and only for the rows that are already retrieved. If you retrieve additional rows after sorting the results, these new rows will be added at the end of the result grid, without any sorting. For large result sets, local sorting can take a long time. In this case it might be better to use an order by clause in the select statement and let the Oracle Server do the sorting.
