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~~
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.
SQL Developer Team
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
order by <some-tcolumn-list-subset>