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.
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
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.
Contains basic editing tools for writing and formatting code.
Contains buttons related to compiling or executing code.
Shows the currently connected schema and enables you to change the schema to execute the code against. Change Current Schema
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:
Both show the DBMS Output, Messages, and Team Coding tabs.
Contains buttons for creating and running macros. See Editor Macros for more information.
Contains buttons for running Code Analysis. About Code Analysis
Contains buttons that support the Team Coding feature.
See About Team Coding in the online help for more information.
The Editor is organized into the following areas:
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
The Object Palette shows a list of the database objects that are in the currently selected schema.
Pick Objects from the Object Palette
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.
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
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. As another example, right click PL/SQL code and then select Compare To for options to compare the code with the database object or a file on disk. You can also select the object, then press F4.
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.
You can customize the shortcut keys. Customize Shortcut Keys
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:
You can customize the behavior of the Editor in many ways.
To set Editor options
The Output window opens whenever an action produces results. The Output window can be re-sized or moved. By default the window 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 right-click menu you can work with the messages displayed in the Output window.
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 activities you have performed during a connection. For example, if you end or begin a Debugger session for a specific connection, a log of this activity is displayed in this tab. |
|
Spool SQL tab |
This tab displays SQL from the Spool SQL command. This is the SQL used by Toad to perform various functions. |
From the right-click menu you can perform the following actions.
|
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. |
|
|
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. |
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:
You can expand the Editor to fill the entire screen, hiding all other desktop panes. The fullscreen Editor does not affect windows such as the Object Palette or Code Snippets.
To toggle the Fullscreen Editor
Select Toggle Fullscreen Editor (F2) from the Edit menu.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
