Chat now with support
Chat with Support

Toad for Oracle 12.11 - Getting Started Guide

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

Customize the Editor

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.


Customize the Editor Layout

Customize your Toad Environment > Customize the Editor > Customize the Editor Layout

You can easily configure which panels display on your Editor desktop and where they display. You can select panels to display one at a time or in groups. When you have configured it, you can save the desktop with its own name, returning to it whenever the need arises. In addition, you can turn on Auto-save current desktop, and however you have the desktop set when you change tabs or close Toad will be how your desktop is defined the next time you open the Editor. You can also split the Editor to easily compare code revisions.

To display panels one at a time

  1. Right-click the Editor and select Desktop.
  2. Select the panel you want to display or hide.

To configure your desktop

  1. Right-click the panel area near the bottom of the window.
  2. Select Desktop | Configure Desktop Layout.
  3. Select the panels you want to display in the Show column, and click the drop down menus in the Dock Site column to change where the panel is docked. By default, all except the Navigator will be docked below the Editor.

To save your desktop

  1. Click on the Desktops toolbar.
  2. Enter the name you want to use for this desktop.

To use a saved desktop

From the drop-down desktop menu, select the desktop you want to use.

To restore a desktop

Click the drop-down arrow on and select Revert to Last Saved Desktop or Restore Default Desktop.

To split the Editor

  1. Right-click the Editor and select Split Editor Layout.
  2. Select Left-Right or Top-Bottom.

To remove the split layout

Right-click in the Editor and select Split Editor Layout | Not Split.


Use Bookmarks

Note: The # must be called from the number row on the keyboard. Using the Number pad will not call the bookmark.

Auto Replace Substitutions

Customize your Toad Environment > Customize the Editor > Auto Replace Substitutions

A substitution is a text phrase that corresponds to replacement text. For example:

  • If you specify a substitution pair of ACT = ACTIVITY_CENTERS, when you type ACT and press space (or other word delimiters), ACT is automatically replaced by ACTIVITY_CENTERS
  • If you specify a substitution pair of NDF = NO_DATA_FOUND and you type NDF and press a delimiter, NDF is automatically replaced by NO_DATA_FOUND

Auto Replace Substitutions are different from aliases in that you can use any group of characters to define and complete the replacement. Aliases do not change the text in the SQL. They are a method of referring to a table by a different name. Substitutions will actually change the text within your code to match the target keystrokes.

To edit Auto Replace entries

  1. From the View menu, select View | Toad Options | Editor | Auto Replace.
  2. Make changes in the Auto Replace grid.

When auto-replace is active, Toad uses several characters as auto replace activation keys. Toad will automatically replace an activation key with the substitution value when it reaches a terminator, for example the space key. For example, if you type teh, Toad replaces it with the word the in the Editor. Or, you can enter the word pack and Toad will expand it to package.

An activation key will cause a matched replacement string immediately before the cursor to be replaced by the substitution value. For example, if you have dept = DEPARTMENT in your auto replace file, you can enter the following:

  • dept[space] and the Editor will expand to DEPARTMENT .
  • dept: and the Editor will expand to DEPARTMENT:.
  • dept; and the Editor will expand to DEPARTMENT;.

Note: The activation key is always included in the expanded substitution.

You can edit this list of keys in the box if you have other needs.

Also from the Editing options window, you can import and export auto substitution files.

Toad comes with a handful of substitution pairs. You can edit and add to the list from the Auto Replace dialog. You can then export the settings to a text file. Alternately, you can create or edit a substitutions file manually and then import it.

Export: Saves the auto replace settings to a separate text file. If you make many changes to your auto replace settings, it is recommended that you export them regularly for back up.

Note: If you do not export your settings to a file before you import a file, they will be lost.

Import: You can import a text file into Toad. This file can be created independently or by exporting the settings you have created in Toad.

Importing a file overwrites the current settings.

Because it can be tedious to add large amounts of information to the substitution file directly from the interface, you may want to edit or create a text file directly.

Use the format of string=replacement string. For example:







Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating