Home > SQL Developer Dialog Boxes ... > Filter
This dialog box is displayed when you right-click a connection node or an object type node (such as Tables) in the Connections navigator and select Apply Filter. Use this box to limit the number of objects of that type that are displayed, according to one or more filter criteria that you specify. For each criterion, specify the following:
Criterion name (list always includes NAME; other criteria depend on the object type)
Operator (for example, LIKE)
Value for comparison (for example EM%)
Case-sensitive option for character data comparison
For example, to display only tables with names that start with EM
, specify NAME
, LIKE
, and EM%
(with the percent sign as a wildcard character).
Any remaining options in this dialog box depend on the context for the filter option.
Override Schema Filter (object type node filters): If this option is checked, any filter criterion specified at the connection level is ignored, and only the object type node filter criteria are applied.
Include Synonyms (object type node filters): If this option is checked, synonyms for objects of this object type are included.
To add another filter criterion, click the Add (+) icon; to delete a criterion, select it and click the Delete (X) icon; to move a criterion up or down in the list, select it and use the arrow icons.
To apply the filter criteria to the Connections navigator display, click OK.
To remove the effects of applying a filter, right-click the object type node in the Connections navigator display and select Clear Filter.