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

Configure Grantees

From the System Privileges window you can grant or revoke selected privileges to/from a selected user. In addition, you can do the same to a selected role or roles.

To grant or revoke a privilege

  1. Click image\Toad0015.gif on the Standard toolbar to open the Schema Browser.
  2. Select a privilege (listed under Sys Privs) and click (Configure Grantees). Alternatively, you can select Configure Grantees from the right-click menu.
  3. Check or clear the appropriate boxes to grant or revoke privileges to users or roles.


Look Up Foreign Keys

When you are editing table data in the Schema Browser, you can look up foreign keys and enter the associated data into the selected table.

Foreign key lookup will also work when the grid is in Read Only mode. You can disable this feature from the Toad Options | Schema Browser | Data and Grids | Enable FK Lookup.

To lookup foreign keys

  1. In the Schema Browser, click the Tables tab.
  2. Select the table you want to edit and in the details pane click the Data tab.
  3. Click in a column that has foreign keys. Click again to activate Editing mode. A drill down button displays.
  4. Click to display the rows in the referential table.
  5. To enter data in appropriate columns in the data grid, select a row and click OK.

The Foreign Key Lookup Window

Within the lookup window, all foreign key constraints are included. If you want Toad to ignore disabled constraints, see Toad Options | Schema Browser | Data.

You can filter rows by typing or by directly editing the query.

To filter rows by typing

  1. Make sure the Filter by box in the lower left is selected.
  2. Put your cursor in one of the displayed columns. You can now filter by typing (if you type "ab" it will filter out rows that do not begin with "ab").

To filter rows by editing the query

  1. Click Edit Query.
  2. Edit the query within the editing window.
  3. Specify variables by clicking the Variable button and entering variable information.
  4. Check that your query syntax is accurate by clicking the Check button.
  5. Click OK to run your new query and filter the lookup grid.


Compare Objects

Toad enables you to view, add, modify, and get information about database objects. You can work with these objects quickly and without having to use SQL commands.


Compare Individual Objects

You can compare individual objects or multiple selected objects to other objects from the Schema Browser. All objects accessible from the Schema Browser can be compared to other objects, but the results are directed to different windows depending on what is selected for comparison.

  • If you select one object to be compared to another object, the comparison is directed to the Single Schema Object Compare window. See the rest of this topic.
  • If you select multiple Users (schemas) the comparison is directed to the Compare Databases window, which is filtered to only those objects on the Object Set tab. Compare Databases
  • If you select multiple objects other than Users, the comparison is directed to the Compare Schemas window, which is filtered only to those objects on the Object Set tab. Compare Schemas.

To compare objects

  1. In the Schema Browser, right-click on an object.
  2. Select Compare with another object. The Single Schema Object Compare window is shown.

    Note: Reference source information will be filled in for you.

  3. Enter comparison source information (a text file or an object in a live schema).

    Select options to apply:

    Option Description

    Compare columns only

    Applies only to tables, views, and materialized views.


    Arranges columns alphabetically before comparing.

    Format before comparing

    Formats both files consistently so that cosmetic differences do not impact your results.

  4. If you are using Toad with the optional DB Admin Module, you can choose to view your results in one of two ways:

    View option Description

    Results as File Compare

    Use the Compare Files utility to compare the two selected objects.

    See Compare Files and Objects in the online help for more information.

    Results as Sync Script

    Only available if the objects chosen have the same name, and are in different schemas, this option the objects and creates a sync script.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating