Chat now with support
Chat with Support

Toad for Oracle 12.12 - 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

About Workspaces

A Workspace is a customized set of windows and connections in Toad that you can name and save. Multiple Workspaces are supported.

You can open one workspace to work in a specific environment, such as Testing, and then quickly switch to another one, such as Development, without having to open one set of windows and connections and close the other.

You can create your own or use the starter Workspace named "Default Workspace." It is initially empty (that is, contains no windows or connections). This Workspace is the only one which cannot be deleted.


Create Custom Workspaces

When you create different workspaces, you can easily resume work in the correct context as soon as you open Toad. Create as many workspaces as you need.

To create a Workspace

  1. Right-click in the main Toad toolbar then select Workspaces to make certain the Workspaces toolbar is shown.
  2. In the Workspace toolbar, click to name and save your Workspace. Your open windows and connections are saved and will be reestablished the next time you open this Workspace.

To open a saved Workspace

Select the workspace from the Workspaces toolbar.

When you open a saved Workspace, you are notified that open connections that are not part of this workspace will be closed. Save any changes that you want to keep before closing those windows and connections.

To save changes to your Workspace configuration

Click in the Workspace toolbar to save changes to your Workspace configuration (newly opened windows and connections).


Use Shortcut Keys

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 Shortcut Keys

Toad provides dozens of default standard shortcut keys, plus you can assign new ones or customize the standard ones. Toad also provides default menu hot keys. These are the underlined keys shown in a menu item that you press along with the ALT key to open that menu item or command. You can change the underlined character from its default.

Note: If you have customized your shortcut keys, you will not automatically be able to use new shortcuts added in future Toad upgrades. However, you can reset your shortcut keys to the default in order to gain access to all new shortcuts.

See Shortcut Keys Options in the online help for more information.

To change a menu hot key

  1. Right-click the toolbar and select Customize.
  2. Right-click the menu item you want to change.
  3. Change the underlined character by changing the location of the ampersand in the Name field. For example, &Tools underlines the T, while T&ools underlines the o.

To change shortcut keys

  1. Click on the standard toolbar.

    Tip: You can also select View | Toad Options.

  2. Select Toolbars/Menus | Shortcuts.
  3. Select the command for which you want to set or change the shortcut keys.
  4. Type the keystrokes you want to use.

    The shortcut key is changed as you type. If there is a conflict with another shortcut key, an asterisk (*) displays in the Conflict column. You can then find the conflict and remove it.

    Note: This option only allows you to use one keystroke after a control key (such as CTRL or ALT).


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating