Log-In to post
* 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 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.
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:
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
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:
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.
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.
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: