Setting SQL Results View Preferences

You can define how you want SQL results displayed.

  1. Select Window > Preferences from the main menu bar.

    The Preferences dialog box appears.

  2. Expand SQL Development, then expand SQL Results View Options.

    The SQL Results View Options dialog appears in the right pane.

  3. In the Display Windows section, select either Single window or Mutliple windows.

    Mulitple windows is the default.

    Single window displays all result set items, for example result sets and messages, in one window.

    Multiple window displays all result set items, for example result sets and messages, in separate tabs.

  4. In the Display Mode section, select Text mode or Grid mode.

    Grid mode is the default.

    Text mode displays result sets in text.

    Grid mode displays result sets in tables.

  5. In the Result Set Option section, do any of the following:
    1. The following choices are determined by your previous selections.
      • If you selected Text mode, you can Show column headings, which is checked by default, or deselect to not show column headings.
      • If you selected Grid mode and Single window, you can Show row number, which is checked by default, or deselect to not show row numbers.
      • If you selected Single window, you can Show row count message, which is checked by default, or deselect to not show row count message.
    2. In Max row count, type the number of rows you that you want fetched in the result set.
  6. In Other Options, if you selected Multiple windows, you can Split all messages into multiple tabs , which is checked by default, or deselect this option.
    1. If you select to Split all messages into multiple tabs, type the number of tabs you want in the Limit tabs number to field.
    2. In Max row count, type the number of rows you that you want fetched in the result set.

      0 = all rows, which is the default.

  7. Click OK.
Related concepts
Database Development Perspective
SQL Results View
Related tasks
Viewing SQL Results
Related reference
Database Development Views
Database Development Preferences