SQL-Developer: Copy result grid cells (columns) with headers

We will use the following Select during this post:

SELECT c.owner, c.table_name, c.column_name, c.data_type 
  FROM ALL_TAB_COLUMNS c 
 WHERE table_name = 'ALL_TAB_COLUMNS'
   AND c.column_name like 'DATA%';

Here is the result:

CopyColumns_01

Select certain cells in the result grid

Before we can copy cells in the result grid, we need to select them:

  1. click (left mouse button) inside the first cell of the grid you want to copy
  2. hold down the left mouse button and move your mouse until all cells you want are selected (marked)
  3. release the left mouse button

CopyColumns_Selected

Select all cells in the result grid

If you want to select all cells in the result grid

  1. click somewhere in the result grid (left mouse button)
  2. press CTRL+a to select all cells

Copy cells from the result grid

Select the cells you want to copy and press CTRL+c.
Go to the program of your choice, I will use Excel here, and press CTRL+v:

CopyColumns_Exel

Copy cells with headers from the result grid

Select the cells you want to copy and press CTRL+Shift+c.
Go to the program of your choice, again Excel here, and press CTRL+v:

CopyColumns_Exel_Header

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s