Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Toad for Oracle 15.0 - Getting Started Guide

Table of Contents

Welcome to Toad

About This Guide

Jump search Toad Advisor Toad World Toad Web-based Training Retrieve License Keys Create Support Bundles

Required Privileges

Required Oracle Privileges Required Window Privileges

Create and Manage Database Connections

About Database Connections Create or Edit a Connection Save Connection Passwords Import/Export Connection Settings Automatically Connect on Startup Use Previous Connections Change Active Connection in Window Test Connections End Connections Commit or Rollback Changes

About the Editor About the Output Window About the Results Grids Toggle Fullscreen Editor Open and Save Files Change Current Schema Find text in the Editor Create a Find and Replace Macro Use Bookmarks Find in Files Move Between Editor Tabs Automatically Back Up the Editor Use an External Editor

Schema Browser Basics

About the Schema Browser View Icon Legend Automatically Refresh the Data Grid Create Schema Browser Filters Create Default Schema Browser Filters Apply Saved Schema Browser Filters Quick-filter the Left-hand Side Filter Data in the Schema Browser Clear Filters

Data Grid Basics

About Data Grids Anchor Column in Data Grid Hide Columns Understand Time Values Sort and Group Data Find in Grid Filter Data Preview Selected Column Include Row Numbers Copy Column Names to the Clipboard

Understand Editable Resultsets Copy Data to Another Schema Compare Data Review Differences Compare Data Duplicates Insert/Delete Rows Post/Revert Edited Data Edit Data in Popup Editor Perform Calculations on Grid Cells Use the Calculator

Work with Database Objects

Describe Objects Find in Objects Copy Objects to Another Schema Create or Alter Objects Use Existing Object as Template for New Objects Drop (Delete) Objects Flashback Tables (Recover Dropped Tables) View Parent/Child Datasets View/Modify Privileges Configure Grantees Look Up Foreign Keys Compare Objects

Compare Individual Objects Compare Multiple Tables Compare Schemas Compare Databases

Rebuild Objects

About Rebuilding Objects Rebuild a Table Rebuild an Index Rebuild Multiple Objects

Write Statements and Scripts

Use the Code Navigator Use the Object Palette Use Code Completion Templates Create Make Code Templates Use Code Snippets Use a Pick List to Complete Code Use Query Templates Format Code Highlight Statements Fold Code Segments Change Text to Upper or Lower Case Swap with Previous Line View File Differences Preview Query Results Save Query Results Copy Statements between Toad and Development Tools View Code Statistics

Work with the Query Builder

About the Query Builder How to use the Model Area Build a Query Create a Sub-Query Populate the Where Clause Populate the Having Clause Use the Generated Query Saving Toad Query Results

Execute Statements and Scripts

About Executing Scripts Execute Single Statements Execute Scripts in the Editor Execute SQL with SQL*Plus

Save Statements (SQL Recall)

Save and Reuse SQL Statements Import/Export Saved SQL

Work with PL/SQL Objects

Load Database Object Reload Object Create New PL/SQL Object Extract Procedures Generate DBMS Output Execute SQL Statements within PL/SQL Execute PL/SQL

About Debugging Debug PL/SQL

Minimum Oracle Database Requirements Start Debugging Set Parameters Set Parameters in Triggers Handle Dependencies Call Stack Window Stop the Debugger Prepare PL/SQL Code for Production View Debug Results Use DBMS Output

Enable DBMS Output View DBMS Output Edit DBMS Output

Create and Run Unit Tests

Script Debugger Overview View Script Output

Set Breakpoints

About Breakpoints Set a Breakpoint

About Watches Add a Watch Use Smart Watches

About Code Analysis Analyze Code in the Editor

Optimize Profile PL/SQL

About the Profilers Set Up the Profilers Use a PL/SQL Profiler View Profiler Results Editor Profiler Tab

Generate Explain Plans

Generate Explain Plans Save Explain Plans

Customize your Toad Environment

Customize Connections

Color Code the User Interface per Connection Organize the Database Connections Grid

Customize Workspaces

About Workspaces Create Custom Workspaces

Use Shortcut Keys

Customize Shortcut Keys Print a List of Shortcut Keys

Customize Toolbars, Menus and Commands

Enable Self-Configuring Menus Show/Hide Toolbars Rename Toolbars, Menus or Commands Create New Toolbars, Menus and Commands Add, Reorder and Remove Commands Show Additional Menus Delete a Menu Reset Default Toolbars Lock Toolbars Effect of Upgrades on Customizations

Customize the Editor

Customize the Editor Layout Use Bookmarks Auto Replace Substitutions

Customize the Schema Browser

Select the Left-Hand Side Display Style Customize Tabs Group Favorite Objects

Customize Schema Drop-Downs

Use Other Quest Software Products with Toad

Integrate Toad with Code Tester for Oracle Launch SQL Optimizer for Oracle Test in Benchmark Factory for Databases

Stop the Debugger

Work with Code > Debug > Debug PL/SQL > Stop the Debugger

If you are debugging a long procedure, you can stop the debugger while it is working.

To stop the Debugger while it is debugging

Click .

The status panel will reset from Running to Idle.
When you have finished debugging your PL/SQL code, discard the debug symbol table: compile it again by pressing F9.

Prepare PL/SQL Code for Production

Work with Code > Debug > Debug PL/SQL > Prepare PL/SQL Code for Production

When you have finished debugging your PL/SQL code, the debug symbol tables are left in the code. This makes your code larger and can slow performance. To eliminate this issue, compile the code and its dependencies and references one last time without debug information.

To compile without debug information

On the main toolbar, turn the debug toggle button to the off position (not depressed).
Compile the code. This recompiles without the debug symbol tables.

View Debug Results

Work with Code > Debug > Debug PL/SQL > View Debug Results

Toad sends your PL/SQL debugger output results to the PL/SQL Results window. This window is located on a tab in the output area of the Editor.

When the PL/SQL execution terminates, the PL/SQL Results window displays the input and output of the code, in a format similar to that shown in the Set Parameters window (parameter name, data type, input, and output). If there is a cursor result, you can view the data stored in each REF CURSOR that is returned via out parameters or as a function result.

From this window, you can create new unit tests (Code Tester for Oracle and utPLSQL), run Code Tester for Oracle unit tests, and also open Code Tester for Oracle. Create and Run Unit Tests From Execution Results

The PL/SQL Results window has the following limitations:

Works only with strongly-typed REF CURSORs.
Works only when the REF CURSOR type is declared in a package belonging to the currently logged-in user.

To view cursor data

Before you execute the PL/SQL, select Fetch cursor data in the Set Parameters window. Set Parameters
After you execute the PL/SQL, double-click (CURSOR) in the PL/SQL Results window.

To access the PL/SQL Results tab

If you cannot see the PL/SQL Results window at the bottom of the Editor, try one the following:

In the Editor toolbar, select PL/SQL Results from the Desktop drop-down menu.
Right-click in the Editor window and then select Desktop | PL/SQL Results.
If PL/SQL Results is already active but still not visible, then you may need to resize or reposition the docked windows to make it visible.

Use DBMS Output

Work with Code

Toad provides an intuitive and efficient way to write, run, and test your SQL and PL/SQL code. Toad supports efficient code management for a single developer or a whole team of developers.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center