Copying Rows from the Interactive SQL Result Set

You can copy rows directly from the result set in Interactive SQL and then paste them into other applications. Copying rows also copies the column headings. Copied data is comma-delimited, which allows other applications, such as Microsoft Excel, to format the copied data correctly. By default, copied data is in ASCII format, and all strings are enclosed in single quotes. You can select only consecutive rows in the result set.

  1. Choose a method to select the rows you want to copy:
    • Press and hold the Shift key while clicking the rows.
    • Press and hold the Shift key while using the Up or Down arrow.
  2. Right-click the result set and select Copy. You can also copy the selected rows by pressing Ctrl-C.

    The selected rows, including their column headings, are copied to the clipboard. You can paste them into other applications by selecting Edit > Paste or by pressing Ctrl-V.