You can view a result set as a grid, as text or as a chart. Which format to use by default can be specified in the Tool Properties dialog, in the SQL Commander/Result Sets category under the General tab. Here you can also specify other things, like if empty result sets should be shown at all, if the SQL that produced the result set should be shown as a tab header tooltip.

Use the buttons to the right in the grid toolbar to select the format. This is an example of the text format.

Viewing as a Grid

When you view the result set as a grid, you have access to the same features as when viewing table data.

Viewing as Text

The text format for a result set presents the data in a tabular style. The column widths are calculated based on the length of each value and the length of the column label.

If you want to combine the text view of a number of result sets into one, select Merge Result Sets from the result set tab right-click menu. A dialog lets you select the result sets to merge:

Auto merging

Using the Merge drop-down menu in the SQL Commander toolbar, you can enable Auto Merge after Execution. You can also select Configure Merging from the menu to adjust various merge options.

Viewing as a Graph

To view the result set as a chart, use the rightmost button in the grid toolbar. Please see the Working with Charts page for how you can arrange the chart.