Chat now with support
Chat with Support

Toad for Oracle 12.12 - Getting Started Guide

Table of Contents Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

View Icon Legend

Many of the panes within the Schema Browser have icons to identify the objects. Toad includes an Icon Legend that you can use to easily decipher these images.

To view the icon legend

Click on the Schema Browser toolbar.


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. Click in the left-hand side. This displays the browser filter for the selected object type and schema.
  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.


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


    • Instead of using the same default filter for each object type, you can have Toad automatically save filters per connection or schema name. See Schema Browser Left-Hand Side Options in the online help for more information.
    • 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.


    Related Documents

    The document was helpful.

    Select Rating

    I easily found the information I needed.

    Select Rating