Toad provides many ways for you to customize the interface to suit your work style and improve your productivity. Most areas of the interface are customizable, from the toolbars and menus, to the grids and workspace itself. You can also set custom defaults for actions, commands, and other tasks that Toad performs for you.
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
Rebuild Objects
Work with Code
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
Customize your Toad Environment
Customize the Toad Interface
Customize Connections
Customize the Toad Interface
Toad provides many ways for you to customize the interface to suit your work style and improve your productivity. Most areas of the interface are customizable, from the toolbars and menus, to the grids and workspace itself. You can also set custom defaults for actions, commands, and other tasks that Toad performs for you.
Color Code the User Interface per Connection
Customize your Toad Environment > Customize Connections > Color Code the User Interface per Connection
You can use connection colors to help you distinguish among open connections. The color coding displays prominently on all windows related to the connection throughout Toad's user interface. For example, you may use red for all production databases and yellow for all test databases. The color coding also extends to any options that display a list of connections, making selecting the desired connection fast and easy.
The color coding displays as follows:
-
Any open window related to that connection
-
Window and Connection bar buttons
-
Status bars
To select a connection color
-
Click
on the standard toolbar to open the Database Login window.
You can also select Session | New Connection.
- Select a color in the Color column in the connection grid, or under Color on the right-hand side.
Organize the Database Connections Grid
The Database Login window displays your connections in a grid format, known as the connections grid. You can organize the connections and reduce the number of connections that are displayed.
To open the Database Login window
Do one of the following to open the Database Login window:
- Click
- Select Session | New Connection.
Display Only Favorite Connections
You can mark the connections that you use frequently as favorites and then hide the other connections until you need to use them.
To select favorite connections
- In the connections grid, select the Favorite check box of the connection you want to make a favorite.
To view only favorites in the connections grid
- Below the connections grid, select the Show favorites only check box.
To view all connections in the connections grid
- Below the connections grid, clear the Show favorites only check box.
Add Custom Columns
You can add columns to the connections grid. For example, you may want to add a Locations column if you manage databases in multiple physical locations, or you may want to add an Environment column to distinguish between Test and Production databases.
To add a custom column
- Click
in the Database Login window toolbar.
- Click Add.
- Enter the name for your custom field.
Group Connections (Create Tree View)
You can group connections by column header to create a tree view. You can add multiple column headers to add grouping levels.
To group connections in the data grid
- Drag a column header into the gray area above the grid.
-
Drag additional column headers to add grouping levels.
To remove grouping
- Drag the column header into the connections grid.
Hide/Display Columns
If you have a small screen area, you can hide some of the columns that display in the connections grid.
To hide or show columns
- Click
in the left-hand side of the grid headers.
- Select the columns you want to display, or clear the check box for columns you want to hide.
Display Only Connections for Selected Oracle Home
If you have many connections using different Oracle homes, you may want to display only those using a particular home in the grid.
To limit connections to one Oracle home
-
Select the Oracle home you want to display in the Connect using field on the right side of the Database Login window.
Note: You can only connect to one Oracle home at a time. This field is disabled if you are already connected to a database.
- Click the Show selected home only check box at the bottom of the window.
Display Tabs for Each Server or User
By default, the connections grid does not contain tabs; it is a unified grid that displays all connections. You can change the grid to display separate tabs for each server or user. Each tab contains a grid of its database connections.
To display tabs for each server or user
- Click
at the top of the Database Login window and select Tabbed by Server or Tabbed by User.
- In addition, select Multi-tab to display the tabs using multiple rows.
To filter the tabs
- To filter the tabs displayed, right-click a tab and select Filter Tabs. Then enter a text string in the search box. If you clear the Partial Match check box, only exact matches are returned. The filter persists while the Database Login window is open.
- To remove the filter, right-click a tab and select Clear Filter.