Copying rows, columns, and cells from an Interactive SQL result set

You can copy cells, rows, and columns directly from the result set in Interactive SQL and then paste them into other applications. Copying rows and columns copies both the column headings and table data into the clipboard.

Prérequis

There are no prerequisites for this task.

You must have executed a query to have a result set.

Contexte et remarques

Copied data is formatted according to the following Interactive SQL options:

You can also change these options from Interactive SQL by clicking Options » Import/Export.

If these options are set to their defaults, the copied data is comma-delimited and the strings are enclosed in single quotes.

Task

In Interactive SQL, retrieve the result set you want to copy.

Option	Action
Copy one row	Right-click any cell in the row and click Copy Data » Rows.
Copy multiple rows	Hold the Ctrl key while clicking cells in the rows, and then right-click and click Copy Data » Rows. The selected row(s), including their column headings, are copied to the clipboard.
Copy one column	Right-click any cell in the column and click Copy Data » Columns.
Copy multiple columns	Hold the Ctrl key while clicking cells in the columns, and then right-click and click Copy Data » Columns. If the Results pane does not contain the entire result set, you are prompted to fetch the remaining results before selecting them. Otherwise, only those results that have been fetched so far are selected.
Copy a cell	Right-click the cell you want to copy and click Copy Data » Cells.
Copy multiple cells	Hold the Ctrl key while clicking cells, and then right-click and click Copy Data » Cells. When you do this, no column headings are copied—only the data is copied to the clipboard, and no quoting is done.

Résultat

The selected data is copied.

Suivant

You can paste the selected information into other applications.

Discuter à propos de cette page dans DocCommentXchange.