Table of Contents
Welcome to Toad
Toad Resources
Jump search
Toad Advisor
Toad World
Toad Web-based Training
Retrieve License Keys
Create Support Bundles
Required 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 Objects
Work with Code
Compare Individual Objects
Compare and Synchronize Multiple Tables
Compare Schemas
Compare and Synchronize Schemas
Compare Multiple Schemas
Compare Databases
Rebuild Objects
Write Statements and Scripts
Customize your Toad Environment
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)
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
Debug
About Debugging
Debug PL/SQL
Analyze Code
Optimize 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
Create and Run Unit Tests
Debug Scripts
Set Breakpoints
Set Watches
Customize Connections
Customize Workspaces
Use Shortcut Keys
Customize Toolbars, Menus and Commands
Use Other Quest Software Products with Toad
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 Schema Browser
Customize Schema Drop-Downs
Table of Contents
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 and Synchronize Multiple Tables |
| Compare Schemas |
| Compare and Synchronize Schemas |
| Compare Multiple 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 |
| Optimize |
| 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
Welcome to Toad™ for Oracle®
Version 12.12
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.
Toad Resources
Toad Resources
Toad provides a wealth of internal and external resources to support you in your work. These resources can help you work more quickly, collaborate across locations, and more.