SQL Developer Quick Tip: Reordering Columns
- by thatjeffsmith
Do you find yourself always scrolling and scrolling and scrolling to get to the column you want to see when looking at a table or view’s data?
Don’t do that!
Instead, just right-click on the column headers, select ‘Columns’, and reorder as desired.
Access the Manage Columns dialog
Then move up the columns you want to see first…
Put them in the order you want – it won’t affect the database.
Now I see the data I want to see, when I want to see it – no scrolling.
This will only change how the data is displayed for you, and SQL Developer will remember this ordering until you ‘Delete Persisted Settings…’
What IS Remembered Via These ‘Persisted Settings?’
Column Widths
Column Sorts
Column Positions
Find/Highlights
This means if you manipulate one of these settings, SQL Developer will remember them the next time you open the tool and go to that table or view.
Don’t know what I mean by ‘Find/Highlight?’
Find and highlight values in a grid with Ctrl+F