Chat now with support
Chat with Support

Toad for Oracle 12.11 - Getting Started Guide

Table of Contents 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

Change Active Connection in Window

Create and Manage Database Connections > Change Active Connection in Window

You can easily change the connection in an open window to a connection you currently have open or a connection that you have recently used.

To change the active connection in a window

Click the arrow beside in the window toolbar and select an open or recent connection from the drop-down.

 

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating