3 Replies Latest reply: Apr 22, 2013 1:06 AM by Gary Graham-Oracle RSS

    How to sort the grid column?

    1002122
      Hi everyone,

      When I select a table and use 'Single Record View', it can not sort by column or value.
      It's so hard to view and find cause there are so many column.....
      Can anyone have any idea?
      Thanks a lot~~
        • 1. Re: How to sort the grid column?
          Gary Graham-Oracle
          Hi,

          It's true that you cannot sort by column in Single Record View, but you can do things prior to opening it which affect number/order of columns shown in that view, and even the ordering of the data when using the arrow icons to move from row to row.

          1. In the grid, right-click on any column heading, select Columns..., then use the Manage Columns feature to reorder or hide/show columns.
          2. Reordering columns in the grid can also be achieved by dragging & dropping a column by its heading.

          3. In the grid, right-click on any column heading, select Sort..., then use the Sort Columns feature to sort the data as desired.
          4. Reordering data in the grid for a specific column can also be achieved by double-clicking on the AZ icon in that column's heading.

          Any changes made for a given table/view are remembered across sessions.

          Regards,
          Gary
          SQL Developer Team
          • 2. Re: How to sort the grid column?
            1002122
            Hi,

            It's so inconvenience to use.
            Thank you very much~~
            • 3. Re: How to sort the grid column?
              Gary Graham-Oracle
              So, if the capabilities of the result grid in the object viewer are inadequate for your needs, just create exactly the view you wish on the underlying table...

              1. select only the columns you wish
              2. order the view's columns in the order you wish
              3. order the data by the column(s) you wish
              4. restrict the data rows by adding a predicate (where-clause)
              create or replace view <name> ( vcolumn-list ) as
              SELECT 
                tcolumn-list-subset
              FROM <table-name>
              WHERE <some-predicate>
              order by <some-tcolumn-list-subset>
              Best Wishes,
              Gary