The Result Set Viewer Preferences dialog enables you to set display options for result-set data.
You can set the following preferences:
|Alternating Row Colors Option||Display alternate Result Set rows in color — Displays the result set with alternating row background colors. This option can be enabled by selecting the box. You can select a different background color by clicking on the 'color' button. This option is disabled by default.|
|Display alternate Result Set rows in color||Select the check box to display color in alternate rows of the result set. Click the color box to open the Color dialog and select a basic color or define a custom color to use.|
|Grid Display Options||
Show Row Numbers — Displays row numbers. This option is enabled by default.
Show Column Headers — Displays column headers. This option is enabled by default.
Show Table Grid Lines — Displays lines between rows and columns on the table grid. This option is enabled by default.
(*) Display Column Titles rather than Column Names — Displays the column titles (if available) rather than the column names, in the column header area. This option is disabled by default. The query must be rerun in order for a change to this option to take effect.
(*) Max Display Row Count — Changes the maximum number of rows to display. The default for this option is 2000. The query must be rerun in order for a change to this option to take effect.
Display Null Value as — Changes the value that is displayed when the data is null. The default for this options is "null".
Long Text Boundary Size — Changes the long text boundary size. If a data value length is longer than the long text boundary size, only the first 20 characters are displayed. The user can view the entire data value by double-clicking the data in the display grid. A pop-up window is presented with the full data value. The default for this option is 150.
Display 1000 Separator in Numeric Columns — Displays a 1000 separator in numeric columns. This option is disabled by default.
Display Negative Numbers in Red — Displays negative numbers in red. This option is enabled by default.
Display Date Format — Changes the date format. This option uses the Java SimpleDateFormat Java Simple Date Format notation to format the date display in the result set. The default for this option is yyyy-mm-dd.
|Copy Column Delimiter||
Delimiter Format — Changes the column delimiter when the Copy data option is used on the grid display. The default for this option is Comma Separated. Other possible choices are Tab Separated and User Defined.
Delimiter Value — Changes the column delimiter value when the User Defined format option is selected.
Copy Include Column Headers — Select to include column headers when the copy data option is used on the grid display.
Copy Include Grid Lines — Select to include cell borders when you use the Copy data option to copy cells from the grid display.
|Viewer Window Options||Select the Reuse Result Set Viewer Window check box to cause the Result Set Viewer to refresh the current window with new result sets generated by the SQL Editor. If you deselect the box, the Result Set Viewer creates a new window for each generated result set.|
Restore Defaults — Restores the default values for the options.
Apply — Applies any option changes. This might cause a refresh of the current result sets displayed in the Result Set Viewer.
OK — Applies option changes and closes the Preferences page. This might cause a refresh of the current result sets displayed in the Result Set Viewer.