SQL Developer: How do I copy data with Column Headers from the output grid?
833541Jan 23 2011 — edited Jan 23 2011Hello,
I am using Version 2.1.1.64.
I run a SQL query, I get the results grid in the "Query Result" window down below. Say I get 10 rows returned, with 5 columns.
I want to Copy this entire grid, plus the column headers/names, to the clipboard. So I can paste it under the original query to document the results of that query.
I can't find any way to do this. I can copy/paste the results grid, but it doesn't copy the headers.
The only way I see to do it is to go through numerous steps to Export to a TXT file, then paste that. Unfortunately, that is a lot of wasted steps if I need to do this over and over, plus, the output gets pasted in an ugly format with double quotes, etc.
It seems like the simplest functionality is to copy/paste the entire results grid, and of course you might the headers. Why is this so complicated/impossible to do?
(I believe Toad has the same problem. DBArtisan allows you to copy/paste the entire results, plus headers, though.)
Any assistance would be appreciated!
Thanks,
John