In Oracle SQL Devleoper, when I copy the results, how can I copy the column headings too?

In Oracle SQL Devleoper, when I copy the results, how can I copy the column headings too?

For example, I don't want:

doucette matthew xona.com etc.

I want:

lastname firstname url      etc.
-------- --------- -------- ----
doucette matthew   xona.com etc.

Answers


I found the answer on https://forums.oracle.com/forums/thread.jspa?threadID=2162606. Once you have selected the results (Ctrl +A) then use Ctrl + Shift + C to copy, this will copy the headers aswell.

Regards


In SQL Developer 3.0.04, once you have run your query, right click on the results grid and select export....

Complete the dialogue box as follows.....

Select next, then finish and then paste into the destination program


If you execute your query using "Run Script" (F5) then your output gets shown in the query results window with column headers that you can copy. That is, if I'm understanding what you want correctly.


Need Your Help

Bring back closed Remote Host Window on PHPStorm

intellij-idea window phpstorm jetbrains-ide remote-host

I accidentally closed () the remote host window in a project of PHPStorm and i can't get it back.