Chat now with support
Chat with Support

Toad for Oracle 13.0 - Getting Started Guide

Copyright 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


© 2018 Quest Software Inc. ALL RIGHTS RESERVED.

This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software Inc.

The information in this document is provided in connection with Quest Software products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest Software products. EXCEPT AS SET FORTH IN THE TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST SOFTWARE ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST SOFTWARE BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST SOFTWARE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest Software makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest Software does not make any commitment to update the information contained in this document.

If you have any questions regarding your potential use of this material, contact:

Quest Software Inc.

Attn: LEGAL Dept

4 Polaris Way

Aliso Viejo, CA 92656

Refer to our Web site ( for regional and international office information.


Quest Software is proud of our advanced technology. Patents and pending patents may apply to this product. For the most current information about applicable patents for this product, please visit our website at


Quest, the Quest logo, and Join the Innovation are trademarks and registered trademarks of Quest Software Inc. For a complete list of Quest marks, visit All other trademarks and registered trademarks are property of their respective owners.


Toad for Oracle Getting Started
Updated - 4/17/2018
Version - 13.0


Table of Contents

Welcome to Toad
About This Guide
Toad Resources
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
Editor Basics
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
Work with Data
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 Individual Objects
Compare Multiple Tables
Compare Schemas
Compare Databases
About Rebuilding Objects
Rebuild a Table
Rebuild an Index
Rebuild Multiple Objects
Work with Code
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
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
About Executing Scripts
Execute Single Statements
Execute Scripts in the Editor
Execute SQL with SQL*Plus
Save and Reuse SQL Statements
Import/Export Saved SQL
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
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
Enable DBMS Output
View DBMS Output
Edit DBMS Output
Create and Run Unit Tests
Script Debugger Overview
View Script Output
About Breakpoints
Set a Breakpoint
About Watches
Add a Watch
Use Smart Watches
About Code Analysis
Analyze Code in the Editor
About the Profilers
Set Up the Profilers
Use a PL/SQL Profiler
View Profiler Results
Editor Profiler Tab
Generate Explain Plans
Save Explain Plans
Customize your Toad Environment
Color Code the User Interface per Connection
Organize the Database Connections Grid
About Workspaces
Create Custom Workspaces
Customize Shortcut Keys
Print a List of Shortcut Keys
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 Layout
Use Bookmarks
Auto Replace Substitutions
Select the Left-Hand Side Display Style
Customize Tabs
Group Favorite Objects
Customize Schema Drop-Downs
Use Other Quest Software Products with Toad
Link to Toad Intelligence Central
Integrate Toad with Code Tester for Oracle
Launch SQL Optimizer for Oracle
Test in Benchmark Factory for Databases
Use Spotlight Essentials


Welcome to Toad

Version 13.0

Toad for Oracle provides an intuitive and efficient way for database professionals of all skill and experience levels to perform their jobs with an overall improvement in workflow effectiveness and productivity. With Toad for Oracle you can:

  • Understand your database environment through visual representations
  • Meet deadlines easily through automation and smooth workflows
  • Perform essential development and administration tasks from a single tool
  • Deploy high-quality applications that meet user requirements; perform predictably and reliably in production
  • Validate database code to ensure the best-possible performance and adherence to best-practice standards
  • Manage and share projects, templates, scripts, and more with ease

The Toad for Oracle solutions are built for you, by you. Over 15 years of development and feedback from various communities like Toad World have made it the most powerful and functional tool available. With an installed-base of over two million, Toad for Oracle continues to be one of the most preferred tools for database development and administration.

It is important to note that Toad for Oracle will only let you do what your DBA has granted you the rights to do via direct privilege grants or indirectly through roles. Toad does not circumvent, augment or otherwise defy your Oracle database security settings. If the DBA does not grant you the CREATE TABLE privilege, then the Create Table in Toad will not work. Likewise If the DBA does not grant you the CREATE PROCEDURE privilege, then the PL/SQL Editor in Toad will be severely limited. You will not be able to compile procedures, functions or packages. Toad only allows you to do what your DBA has permitted you to do.


About This Guide

The goal of this guide is to help you start using Toad quickly by learning basic features and tasks. Toad is a very diverse and powerful tool, and there are many features not covered here. In many cases, a feature may be introduced in this guide, with further instructions to see the online help. Refer to the online help for thorough documentation on all Toad functionality. You can access the help at any time by pressing F1. You can:

  • Use the Table of Contents to get an outline view of all the components of Toad and links to the related documentation. You can also go directly to this page by clicking Help | Contents.
  • Use the Search tool to find topics based on keywords that you input.
  • Use the Favorites tab to bookmark topics to which you refer frequently.


Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating