ThatJeffSmith

How to Copy Only Column Headers from Query Results in Oracle SQL Developer

Short and sweet post today – let’s say you’ve written a SELECT *, and your query results have some column headers you want to copy out. Yes, you could copy out the result set WITH the column headers, but maybe you JUST want the column names themselves.

Right mouse on the column headers. not in the grid.

Right mouse on the column headers. not in the grid.

Note you need to select which column headers you want copied by selecting at least once cell in the grid. So in the screenshot above I have ctrl-clicked 3 of the 5 columns by selecting their associated cells. Also, this is a fairly new feature, be sure you’re running v3.2.20_09 of Oracle SQL Developer.

Just another stupid copy and paste trick for your collection :)

SQL Developer, The Movie!