Toad for Oracle 15.0 - Getting Started Guide

Automatically Refresh the Data Grid

You can set the Schema Browser to automatically refresh the data grid while you are working with a specific object. This setting only lasts for your active dataset, and turns itself off if you select another object or close the Schema Browser.

To automatically refresh the data grid

Select Auto Refresh in the Data tab toolbar (right-hand side of the Schema Browser).

Create Schema Browser Filters

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

To create browser filters

1. 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.

2. Complete the fields as necessary.
3. 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.
      

4. 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

1. Select Session | Schema Browser Filters.

2. 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

1. Click the arrow beside and select a saved filter from the list.
2. 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.