Toad for Oracle 2025 R3 - Getting Started Guide

Object filters reduce the number of objects displayed in a schema.

To create browser filters

Depending on the Schema Browser style you have selected (tabbed or dropdown vs. treeview) do one of the following:

Tabbed or dropdown: Select the object type that you want to filter, for example Tables or Roles, and then click on the Schema Browser toolbar.

Tree view: Right click the object type in the tree view, then select Filter object_type.
Complete the fields as necessary.
To save the filter, click Saved Filters and select Save Current Filter As.
1. 'Save filter data for all object types,' or
2. 'Save filter data for roles only' (in this example).
  Saves into an SBFLT file. When such a file is reloaded, current settings for other object types are not changed.
To customize or review the query before applying it, select View/Edit Query Before Executing and click OK.

Notes:
- Do not change the SELECT list.
- When entering the IN clause, you must enclose the table name in single quotes ('TEST'). This lets you enter multiple table names ( such as 'TABLE1', 'TABLE2', 'TABLE3') or enter a sub-query.

Create Default Schema Browser Filters

You can create a default filter for each object type, which is used for all schemas.

Notes:

Instead of using the same default filter for each object type, you can have Toad automatically save filters per connection or schema name.
This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To create default filters

Select Session | Schema Browser Filters.
Select an object type on the left and set the filter options. Create Schema Browser Filters

Note: When you click OK, Toad saves default filters in a file named Toad_DEF.SBFLT in the User Files folder.

Apply Saved Schema Browser Filters

To apply a saved filter

Click the arrow beside and select a saved filter from the list.
If the filter you want is not listed, complete the following steps:
1. Click in the left-hand side of the Schema Browser.
2. Click Saved Filters in the upper right of the dialog and select Load Filter
3. Select the filter and click Open.
4. Click OK to apply the filter and close the dialog.

Wildcard	Description
* and %	Use for multiple character wildcards. Note: % is the Oracle standard.
? and _	Use for single character wildcards. Note: _ is the Oracle standard.
!	Use to exclude the following characters. One exclamation point affects the entire string. For example, !A;B would return everything that does not start with A or B.
Notes: You can use multiple filters by separating them with a semicolon. For example, A;B would display everything that starts with A or B. The QuickFilter maintains a history of up to 25 items, listed most recent first. Right-click the QuickFilter to access this list.

Wildcard

Description

* and %

Use for multiple character wildcards.

Note: % is the Oracle standard.

? and _

Use for single character wildcards.

Note: _ is the Oracle standard.

Use to exclude the following characters.

One exclamation point affects the entire string. For example, !A*;B* would return everything that does not start with A or B.

Notes:

You can use multiple filters by separating them with a semicolon. For example, A*;B* would display everything that starts with A or B.
The QuickFilter maintains a history of up to 25 items, listed most recent first. Right-click the QuickFilter to access this list.