You can copy rows directly from the result set in Interactive SQL and then paste them into other applications. Copying rows copies both the column heading and table data into the clipboard. Copied data is comma-delimited and all of the strings are enclosed in single quotes.
Select the row(s) you want to copy. To select a row(s):
Press and hold the Shift key while clicking the row(s).
Press and hold the Shift key while using the Up or Down arrow.
Press Ctrl+C to copy the selected row(s).
The selected row(s), including their column headings, are copied to the clipboard. You can now paste them into other applications.
You can copy a single value from the result set by selecting a value, right-clicking the result set and choosing Copy Cell from the popup menu. When you do this, no column headings are copied—only the data is copied, and no quoting is done.