Toad provides a number of ways to end a database connection.
To end one connection
Select Session | End Connection.
Or
Click 
Or
Right-click the connection name in the toolbar, then select End Connection.
To end all connections
Select Session | End All Connections.
Tip: You can also right-click the connection in the Connection Bar, and select Commit or Rollback. You can also commit or rollback a session from Session | Transaction in the main menu.
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.
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
