This trick’s title might actually be longer than the content – so guaranteed QUICK read!

Question from a reader: is there a way to alphabetize the columns in the Single Record View?

Available from any grid, just remember to right-click.
Available from any grid, just remember to right-click.

Quick Answer: No…

Right click on any data grid and choose 'Single Record View.'
Columns shown in order in which they appear in the table

Column order is usually something the application architect or data modeler deemed important, so we always show the column in the order in which they’re defined in the DDL. BUT, when browsing really wide tables, it can be hard to find the column you’re looking for. So I can see why you might sometimes really want an alpha display.

So I do offer a workaround:

Query the table with the column order YOU want in the SELECT.

The trick:

  1. open the table viewer
  2. go to the columns list
  3. Sort
  4. Select the columns in the grid
  5. drag-and-drop to the worksheet

You’ll get the comma separated listed of columns, in the order you want. Run query, right-click, voila.

Did you know you could drag and drop from the columns page?
Did you know you could drag and drop from the columns page?

I realize some of you might find this too be too much work to get to what you want, but I hope you see at least you do have full control over how the data is displayed, and there are a few shortcuts to get there quicker.

thatjeffsmith
Author

I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

Write A Comment