ASA Getting Started
  Using Interactive SQL
    Using Interactive SQL to display data

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. Copied data is in ASCII format, and all of the strings are enclosed in single quotes. You can select only consecutive rows in the result set.

To copy rows from the Interactive SQL result set

1. 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

2. Right-click the result set and choose Copy from the popup menu. You can also copy the selected row(s) by pressing Ctrl+C.

   The selected row(s), including their column headings, are copied to the clipboard. You can paste them into other applications.

Copying individual values from the result set 

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.