Chat now with support
Chat with Support

Toad for Oracle 16.1 - Getting Started Guide

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

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.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating