Chat now with support
Chat with Support

Toad for Oracle 13.1.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

Use the Calculator

Work with Data > Use the Calculator

You can access a calculator within Toad data grids. To use the calculator, the table must be editable. Understand Editable Resultsets

To access the calculator

  1. Click in a numeric cell. A drop-down arrow displays.
  2. Click the arrow to display the calculator.

 

Work with Database Objects

Work with Database 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.

 

Describe Objects

Work with Database Objects > Describe Objects

You can use the Describe Objects feature anywhere in Toad to find objects and display their information in the Describe Objects window. The Describe Objects window displays the same information you would see in the right-hand side of the Schema Browser.

Note: You can describe many objects types through database links. However, the following object types are not supported: policy, policy group, java, refresh group, resource groups/plans, sys privs, and transformations.

To immediately describe the object

  1. Select the object and press F4.

    Tip: You can also right-click the object and select Describe.

  2. If multiple objects have the same name, select the appropriate object from the Multiple Object Found window. (This only applies to the object types in DBA_OBJECTS.)

To specify the object schema and name before describing the object

  1. Press CTRL+D to open the Quick Describe window.
  2. Enter the object name in the Object Name field. You can complete the rest of the fields to refine your search. These fields are helpful when multiple schemas may contain objects with the same name, or when different object types have the same name (for example, a SYSTEM user and table).
  3. Click Describe and Close to open the object in the Describe Objects window and close the Quick Describe window. If you click Describe instead, the Quick Describe window remains open.

 

Find in Objects

  • From the Toad toolbar, click .
  • From the Search menu, select Object Search.
  • On the DB Misc tab of the Automation Designer, double-click (Object Search) to add the action to your app, then double-click the action to open the Properties dialog.
Related Documents