How to Copy Query Results With Column Headers in Toad?

How to Copy Query Results With Column Headers in Toad?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL / Toad
  • 1 min read

In Toad, when you execute a query then Toad shows the results in a data grid. You can copy those results with column headers using the keyboard. Below is the example is given to copy query results with column headers in Toad.

Copy Data Grid Rows With Column Headers in Toad Example

  1. After executing the query, click on the data grid.
  2. Press Ctrl+A to select all the rows or select the multiple rows by holding down the Shift key and click on the leftmost button of the row.
  3. Then press Ctrl+Insert key to copy the grid data with column headers.

See also: