ORACLE - How to copy column names or header from query result set in ORACLE SQL DEVELOPER ?

When we are working on ORACLE SQL DEVELOPER, we come across many situations where we need to copy only column names of a table or column names along with all data from query result set to excel or notepad. This can be done by the following ways:

COPY ONLY COLUMN NAMES:

When you want to copy only column names from result query, select cells corresponding to the columns which you want to copy. Right click on the column name and select option "Copy Selected Column Header(s)". This way column names get copied in clipboard which you can paste wherever you want. See below screenshot .

COPY COLUMN NAMES ALONG WITH DATA:

When you want to copy all column names along with all data  from result query, select all rows in result query set. After that hit SHIFT+CONTROL+C. All data along with header gets copied to clipboard which you can paste wherever you want. See below screenshot.

If you like this post, don't forget to share and post comment.