Chat now with support
Chat with Support

Toad for Oracle 17.1 - Getting Started Guide

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

Group Favorite Objects

You can group objects that you use frequently into a tab on the Schema Browser. These different objects can be grouped into one or several folders. Folders are specific to an instance (not a connection or a schema).

Note: The configuration file for this tab is saved as Projects.lst in the User Files folder.

To group favorite objects

  1. Click image\Toad0015.gif on the Standard toolbar to open the Schema Browser.
  2. Select Favorites in the object list in the left-hand side.
  3. Add one or more folders to group the objects:
    1. Click on the Favorites toolbar.
    2. Enter a folder name.
  4. Add objects to a folder.
    To do the following: Complete these steps:
    To search for and select objects
    1. Click on the Favorites toolbar.
    2. Search for objects. Object Search
    3. Highlight the objects you want to add in the Results tab and click .
    4. Select the folder where you want the object.
    To add objects directly
    1. Right-click an object in the left-hand side and select Add to SB Favorites List.
    2. Select the folder where you want the object.

    To add scripts/files
    1. Right-click the folder where you want the item in the Favorites list and select Add Files.

    2. Select the file and click Open.

      Note: Multi-select files to add more than one at a time.

    3. Select the folder where you want the object.

    Tips:

    • To remove objects from a folder, select the object in the Favorites list and click .
    • To empty or remove favorites folders, right-click the folder and select Remove Folder to remove the folder and its contents or Empty Folder to leave the folder in the list but remove its contents.

 

Customize Schema Drop-Downs

You can customize schema drop-downs by creating a list of favorites, hiding schemas, setting the default schema for connections, and other options. Changes apply to all windows with the schema drop-down, such as the Editor and Schema Browser.

To set a default schema

Right-click the schema in the schema drop-down and select Set <schema name> to Default Schema.

To customize schema drop-downs

  1. Right-click the schema drop-down and select Customize.
  2. Select schemas to categorize and click the > button.
  3. To hide schemas, select Hidden Schemas in the Category field for the schema.
  4. To create a new category, enter the category name in the Category field for the schema. The new name becomes available in the Category drop-down.
  5. To change when the schema is categorized, select the When to Categorize field for the schema and click .

 

Use Other Quest Software Products with Toad

You can access the features of the following Quest products from within Toad to expand your ability to manage your code and your database.

 

Integrate Toad with Code Tester for Oracle

Code Tester for Oracle automates the process of testing PL /SQL programs, making it possible for you to identify bugs and verify program correctness in a fraction of the time it has taken previously. Toad contains a subset of Code Tester functionality to allow you to create unit tests as an integral part of your code execution.

Run unit testing on your code

Note: Toad contains a subset of Code Tester functionality. Code Tester for Oracle itself is a standalone product. For full information about using Code Tester, please open Code Tester and see its relevant documentation.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating