Query Output Data
You can view query output in the SQL Editor using dynamically generated tab
pages at the bottom of the Query Output docking pane. One tab is output per
each result set. The output page presents returned data in a grid with rows
and columns.
When you submit SQL statements for execution, any existing output pages are
deleted and new ones are created.
You can save the returned data of the output page as text files in one of
the following formats:
- Tab-separated text file
- Pipe-separated text file
To save an output page
- Click the Output page containing
the data that you want to save.
- Choose SQL->Export
Query Data or right click the data and select Export All Data
from the popup menu. The Save As dialog box appears.
- Specify the directory and filename.
- Select one of the following
file extensions from the Save as type list box: Text File
Tab-Separated, Text-File Pipe Separated.
- Click Save to
save your output data to a specified directory and filename.
To copy returned data to the
clipboard
- Click the output page containing
the data that you want to save.
- Click the cell or select a group
of rows that you want to copy.
Use CTRL+Click or SHIFT+Click to select multiple rows. - Right click on the data and
select Copy Cell or Copy Selected Rows
from popup menu.
To view and save data in the grid
cell
- Click the output page containing the data that you want to save.
- Right-click the data and select Open Cell Viewer from the popup menu or double-click on the cell. The Cell Viewer window will open.
- To view and save another cell, do not close Cell Viewer; just double-click the cell. The data will be replaced in the open Cell Viewer Window .
See Also