ThatJeffSmith

SQL Developer Quick Tip: Reordering Columns

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

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.

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.

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

Find and highlight values in a grid with Ctrl+F