Connections View Displays configured database connections
Object Explorer Browses through schema objects
Object Describe Views detailed information about an object
SQL Worksheet Edits and executes SQL statements
Projects and Toad Extension for Eclipse Nature Adds additional functionality to new or existing projects
Syntax Check Verifies SQL code on-the-fly
Deployment Allows to deploy objects to database using default connection or selected connection
Object status Shows status of object in default database
Export to HTML/XML/CSV Outputs data to selected format
SQL Recall Views a history of your executed SQL statements
SQL Monitor Monitors all SQL coming from Toad Extensions
DBMS Output View* Views DBMS_OUTPUT results
Stored Procedure Editor Edits Stored Procedures, Views and Triggers
Search dialog Searches through database source code
Quick Doc View Views column information comments
Outline View Views the logical structure of a database object
Sessions View* Monitors or kills sessions in the database
Parameters View* Displays an overview of the database and session parameters

* View is available only for Oracle databases.


Connections View

In the Connections View, you will see all of the defined database connections. Here you can view or connect to your saved database connections, or define a new one.
This view also shows all of the connections associated with the various editors including: SQL Worksheet, Stored Procedure Editor; and, Detail Browser.

For Oracle connections, schema filters can be optionally defined.

Object Explorer

The Object Explorer provides an easy way to navigate database objects. The database objects are displayed for the currently active Connection (unless a Schema filter has been defined or selected for an Oracle connection).

Stored Procedures and Functions can be executed from Object Explorer.

Detail Browser

The Detail Browser shows each database object's features and allows for their modification. The functions available depend on the particular database object.

  

SQL Worksheet

As for the different editors, the SQL Worksheet handles processing of individual SQL statements during a database session; and, the SQL Script Editor enables development and storage of SQL scripts.

Any executed statements can be viewed in the SQL Monitor log. SQL execution plans are also graphically displayed which provide a detailed outline for how the database engine processes each statement.

There is also an integrated PL/SQL Profiler that records and presents the execution metrics for each statement within stored procedures and triggers.

Bind Variables are available for Oracle databases:

SQL Recall

SQL Recall shows the last 100 statements executed within the SQL Worksheet. The statements are grouped by Connections, or the database connection in use when last executed, and they are fully searchable.

All of the entries in SQL Recall can be sent to the SQL Worksheet for to re-execution.

  

SQL Monitor

The SQL Monitor shows all of Toad Extension for Eclipse's executed SQL statements, their runtime and any error messages.

  

Projects and Toad Extension for Eclipse Nature

Toad Extension project or any other project with Toad Extension Nature enables additional useful features, incl. Object Status, Deployment etc.

Syntax check

Syntax Check is a powerful feature that helps you to verify your SQL code no matter whether connected to the database. Benefits:

  • Errors are recognized automatically, on-the-fly.
  • Graphical representation of error bubbles through project structure up to the project level (Navigator View, Package Explorer, Project Explorer)
  • Hints are displayed when you move your mouse cursor over the error icon in editors (white cross in red circle)
  • Details can be displayed in Problems View

  

Deployment

Functions, stored procedures and other objects can be easily deployed to known databases. Known database is a database recognized by an existing connection. In other words, you need to specify a default connection for your project or establish a connection in the Connection view, or import connections from Toad for Oracle, to be able to deploy SQL to the database.

  

Object Status

You can have your stored procedures, functions and other pieces of code in your project. Object status feature offers you a method to verify whether the code you see in files is identical to the objects in your database (assuming you have specified the default connection in project properties).

You may need to update an object from the database. Then use the option Update from Database

Export data to HTML/XML/CSV

In preferences you can specify settings for each output format.

  

DBMS Output View

The DBMS Output view displays the output from a PL/SQL script once that script is executed.

  

Stored Procedure Editor

The Stored Procedure Editor allows users to create and modify the stored procedures, views and triggers. They offer this many features you'd expect from a modern development environment today:

  • Syntax Highlighting
  • Auto indentation
  • Cross-references to other database objects and inner functions / procedures
  • Code Templates
  • Documentation Support
  • Convenient processing functions

The Stored Procedure Editor loads these objects directly from the database.

Search Dialog

The Search Dialog scans all database objects or source code files for specific text. The search can contain wildcards and searches can be made case sensitive.

Double clicking a search result opens the item in the Stored Procedure Editor.

Open Database Object

Press CRTL+SHIFT+D to display the Open Database Object window that can be used for quick object search in Oracle Database structures.

Quick Doc View

The Quick Doc View shows all database objects and gives descriptions of all characteristics for each object.

  

Outline View

The Outline View shows the logical structure of PL / SQL source code and works in conjunction with the Stored Procedure Editor. A click on a procedure in the Outline View sets the cursor in the accompanying Stored Procedure Editor to the respective line of code in the stored procedure.

Any changes made in the Stored Procedure Editor updates the code in the Outline view.

  

Session View

The Sessions view displays database sessions and their status. The display is updated continuously and changing values are highlighted.

The display can be filtered, eg for active sessions, and individual sessions can be terminated.

Parameters View

In this view important parameters of the database are displayed:

  • All Oracle parameters with their current value
  • NLS parameters of the database instance and session
  • Version information