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

Editor Basics

Editor Basics

The Toad Editor lets you write and edit many types of statements and code, and Toad provides many options to customize the Editor's behavior. You should get to know the Editor well, because it supports most of the core functionality of Toad, and much of your work will be done there.

 

About the Editor

Editor Basics > About the Editor

The Editor window is the foundation for working with many types of statements and code. The Editor attaches itself to the active connection in Toad, but if you do not have a connection you can still use it as a text editor.

This topic describes the basic Editor components. As you use other features in Toad or if you customize the Editor layout, the appearance of the Editor will change.

Editor Toolbars

The Editor has the following default toolbars. Hover your mouse over a button to determine its functionality. You can show or hide toolbars and buttons to customize your work area. Show/Hide Toolbars

File

The main Editor toolbar that contains functionality for changing sessions, opening and saving files, printing, launching external software related to Toad, creating new PL/SQL objects, and launching the SQL Recall tool for saving and viewing statements.

Edit

Contains basic editing tools for writing and formatting code.

Execute

Contains buttons related to compiling or executing code.

Current Schema

Shows the currently connected schema and enables you to change the schema to execute the code against. Change Current Schema

Desktop

Shows the current desktop layout and enables toggling between SQL and PL/SQL desktops.

The SQL desktop is mainly for working with scripts, while the PL/SQL desktop is for working with procedures, functions and packages.

The desktop determines what tabs are displayed in the Editor:

  • The SQL Desktop shows the Data Grid, Trace, Query Viewer, Explain Plan, and Script Output tabs.
  • The PL/SQL Desktop shows the Call Stack, Breakpoints, Watches, Profiler, and PL/SQL Results tabs.
  • Both show the DBMS Output, Messages, and Team Coding tabs.

Macro

Contains buttons for creating and running macros. See Editor Macros for more information.

Code Analysis

Contains buttons for running Code Analysis. About Code Analysis

Team Coding

Contains buttons that support the Team Coding feature.

See About Team Coding in the online help for more information.

Intelligence Central

Contains buttons for connecting to a Toad Intelligence Central server to download or upload supported artifacts. Link to Toad Intelligence Central from Toad

Editor Layout

The Editor is organized into the following areas:

Navigator Panel

The Navigator Panel is a desktop panel that displays an outline of the Editor contents in the active tab. You can click on the items listed to navigate to that statement in the Editor. The Navigator Panel is displayed on the left-hand side by default, but you can change where it is docked.

If the Navigator is not shown, right-click the Editor and select Desktop | Navigator.

Move through Code with the Navigator

Object Palette

The Object Palette shows a list of the database objects that are in the currently selected schema.

Pick Objects from the Object Palette

Editor

The main Editor window displays code in tabs. You can open new tabs for different bits of code, or different types of code. SQL and PL/SQL can go in the same tab. Toad can tell where the cursor is located and compile PL/SQL or run SQL as required.

Note: If you have multiple statements in the Editor, you must trail them with a valid statement terminator such as a semi-colon.

Desktop Panels

The desktop panels contain many options for tab display, depending on what kind of code you are working with and what you want to do with it. In addition, you can configure how these panels display to make Toad work for you. Customize the Editor Layout

Editor Right-click Menu

The right-click menu of the Editor contains many options to help you work with code. When you are trying to figure out how to do something, right-click the Editor to see if there is a menu or command for it. For example, right click a table and then select Describe to open the Describe Objects window. You can also select the object, then press F4.

Shortcut Keys

Toad provides dozens of standard shortcut keys, plus you can assign new ones or customize the standard ones. Toad also allows you to print out your current list of shortcut keys.

Customize Shortcut Keys

You can customize the shortcut keys. Customize Shortcut Keys

Editor Results Area

At the bottom of the Editor are tabs that display results of your actions with code.

Depending on your Toad Edition, any of these tabs display results:

Output Area

About the Output Window

Editor Options

You can customize the behavior of the Editor in many ways.

To set Editor options

  1. Select View | Toad Options | Editor.
  2. Select an options group and then press F1 for information about those options.

 

About the Output Window

Editor Basics > About the Output Window

The output window displays whenever there are results of an action. The Output window can be sized however you want. By default it is docked at the bottom of your screen.

In addition, the output window displays error messages, and other general information Toad creates for you. Output is sent to various tabs as needed. Using the popup menu you can work with the messages displayed in the Output window.

Various Tabs

Output is sent to various tabs in this window as needed.

Tab

Contents

General tab

This tab provides general information.

<connection> tab

This tab provides information about what you have done during a connection. For example, if you end or begin a Debugger session for a specific connection a log of this will be displayed here.

Spool SQL tab

This is where SQL is displayed from the Spool SQL command. This is the SQL Toad uses to perform various functions.

Right-click Menu

From the right-click menu you can do several things.

Command

Result

Clear

Clears all messages in the active output tab.

View Messages

Displays the selected messages in a dialog box. This is useful when a message is too long to view in the Output window, or contains linefeeds.

Copy

Copies the contents of the Output window to the clipboard.

Print

Prints the contents of the Output window.

Save to File

Saves the contents of the Output window to a text file.

Spool SQL to Screen

Toggles spooling.

 

About the Results Grids

Editor Basics > About the Results Grids

At the bottom of the Editor are tabs that display results of your actions with code within the edit window.

Depending on your Toad Edition, any of these may display results:

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating