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.