Chat now with support
Chat with Support

Toad for Oracle 12.11 - 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

Apply Saved Schema Browser Filters

Schema Browser Basics > 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.

 

Quick-filter the Left-hand Side

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.

Filter Data in the Schema Browser

Schema Browser Basics > Filter Data in the Schema Browser

The Schema Browser has the following methods to filter data:

  • Filter/Sort—This is a server-side filter that limits which rows are retrieved from the database. This method is much faster than the grid filter when you are filtering a large dataset. Access this filter by clicking the button in the tab's toolbar.
  • Filter Data—This is a client-side filter that retrieves all rows from the dataset before filtering them. Access this filter by right-clicking the data grid.

To filter data in the Schema Browser

  1. Click in the tab's toolbar (right-hand side of the Schema Browser).
  2. Complete the fields as necessary.

 

Clear Filters

  • 'Clear Filter for <object type>,' or
  • 'Clear Filter For All Object Types'
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating