Toad Extension for Eclipse Features
| Connections View | Displays configured database connections | ||
| Schema Browser | 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 | ||
| PL/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.
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.
The Schema Browser 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 Schema Browser (Oracle Database only).
The Detail Browser shows each database object's features and allows for their modification. The functions available depend on the particular database object.
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 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.
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 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
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.
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
In preferences you can specify settings for each output format.
The DBMS Output view displays the output from a PL/SQL script once that script is executed.
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.
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.
Press CRTL+SHIFT+D to display the Open Database Object window that can be used for quick object search in Oracle Database structures.
PL/Doc View
The PL / Doc View shows all database objects and gives descriptions of all characteristics for each object.
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.
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.
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
