Exclude Rows

Use Exclude to remove one or more rows that satisfy the specified criteria from the display in the Table Editor.

In the Exclude dialog, you specify a search string. You also specify whether the search should proceed forward or backward, wrap to search all of the available data, be case-sensitive, or locate complete words. Click Find Next to locate the first occurrence of the search string. Then, click Exclude to exclude the row containing the single instance of the search string or click Exclude All to exclude all rows that contain the search string.

Excluded rows are retained in the fetch set. A thick line between rows indicates the presence of hidden rows. Position the pointer on the thick line to display the number of hidden rows. You can right-click and select Show Excluded Rows on the shortcut menu to show all of the rows.

To use Exclude

  1. Right-click in a grid column heading and select Exclude from the shortcut menu to open the Exclude dialog.
    exclude dialog, described below
  2. On the Criteria tab, specify the string or value you want to exclude.
  3. Select a direction for the search.
  4. Select matching options, as needed.
  5. On the Columns tab, select the columns you want to search. The column in which you right-clicked is selected by default.
  6. Select Find Next to begin the search.
  7. Select Exclude to hide rows one at a time, or select Exclude All to hide all rows that satisfy the specified criteria.