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

sql oracle oracle-sqldeveloper
Xonatron picture Xonatron · Nov 3, 2011 · Viewed 46.8k times · Source

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.

Answer

Marius Botha picture Marius Botha · Oct 16, 2012

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

Related questions

Use tnsnames.ora in Oracle SQL Developer

I am evaluating Oracle SQL Developer. My tnsnames.ora is populated, and a tnsping to a connection defined in tnsnames.ora works fine. Still, SQL Developer does not display any connections. Oracle SQL Developer Soars mentions, that if you have …

Read More
How can I find which tables reference a given table in Oracle SQL Developer?

In Oracle SQL Developer, if I'm viewing the information on a table, I can view the constraints, which let me see the foreign keys (and thus which tables are referenced by this table), and I can view the dependencies to …

Read More
Oracle SQL escape character (for a '&')

While attempting to execute SQL insert statements using Oracle SQL Developer I keep generating an "Enter substitution value" prompt: insert into agregadores_agregadores ( idagregador, nombre, url ) values ( 2, 'Netvibes', 'http://www.netvibes.com/subscribe.php?type=rss\&url=' ); …

Read More