Toad for Oracle 15.0 - Getting Started Guide

Test Connections

To test connections if the session has dropped

Select Session | Test Connections (Reconnect)
or

Session | Test All Connections (Reconnect)

To test connections in the Database Login window

Select connections in the grid and click . Toad opens a new session to test the connection and lists any errors that occur.

End Connections

Toad provides a number of ways to end a database connection.

To end one connection

Select Session | End Connection.

Or

Click in the standard toolbar to end the currently active session. You can also click the arrow by the button to select a different open connection to end.

Or

Right-click the connection name in the toolbar, then select End Connection.

To end all connections

Select Session | End All Connections.

Commit or Rollback Changes

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.

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.