This discussion is archived
2 Replies Latest reply: Dec 21, 2012 11:04 PM by dz_r RSS

Missing sorting

dz_r Newbie
Currently Being Moderated
SQL Developer version 3.2.20.09

(1) View -> DBA -> Security -> Users, right click "Create new"
Drop down list "Default tablespace" is unsorted which makes difficult to find the one (from dozens) you are looking for.
Alphabetically sorted list would be much better.

(2) Tree navigator -> Tables -> Open (specific table) -> "Indexes" tab
List of columns of the index seems to be unsorted (in 90% of cases columns are displayed in proper order but sometimes they are not)
Columns of the index should be displayed sorted by COLUMN_POSITION.

Is it possible to introduce above small improvements to SQL Developer?
  • 1. Re: Missing sorting
    Gary Graham Expert
    Currently Being Moderated
    Hi,

    Typically one makes this kind of request at the SQL Developer Exchange: http://sqldeveloper.oracle.com/

    For (1), the tablespace names are retrieved from the database in alphabetic order but, due to temporary storage in an unsorted Java map, there is no guarantee about sort order when copied into the drop-down list. Actually, reverse order may be most likely. Note, however, they do appear in sorted order in the Quotas tab due to explicit sorting. Sorting in the drop down list will be fixed in the next release.

    In the meanwhile, see if the following workaround helps. If the first letter or two of the tablespace name is significant, and you are a quick typist, you can easily skip through a long list of unsorted names by repeatedly typing the first letter or two of the name.

    For (2), if you are talking about the top table, the summary of all indexes for a table with the first four index columns per index displayed horizontally, then those are definitely in order by column position. After clicking on a specific index, another table appears below showing all index columns (one per row) for that index. I'm not sure if any default sort is provided or if it is random, but you can easily access a comprehensive sort dialog by right-clicking any column heading. Some may want sorting by column name or length instead of position, for example.

    Regards,
    Gary
    SQL Developer Team
  • 2. Re: Missing sorting
    dz_r Newbie
    Currently Being Moderated
    Thanks for reply.

    (1) In the meanwhile, see if the following workaround helps. If the first letter or two of the tablespace name is significant, and you are a quick typist, you can easily skip through a long list of unsorted names by repeatedly typing the first letter or two of the name.

    Fast typing works fine.

    (2) That was the second situation:
    After clicking on a specific index, another table appears below showing all index columns (one per row) for that index. I'm not sure if any default sort is provided or if it is random

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points