From the Eclipse Workbench toolbar, select Window|Open Perspective|Other.
Select Database Development from the menu.
The Database Development perspective opens. An editor and several views become available to you. These include:
SQL Editor allows you to create or edit procedural objects and SQL files. This portion of the perspective is your primary work area.
WorkSpace Navigator lets you browse, select, and open SQL files in SQL Editor.
From Database Explorer you can select events, procedures, functions, and triggers to edit, run, and debug in SQL Editor.
Outline view allows you to track the progress of your work and maneuver between elements. Access it by selecting the
icon at the upper left of the perspective or by selecting Window|Open
Views|Other|Basic|Outline. SQL Execution Plan view displays the execution plan for selected SQL statements in the SQL Editor. You can use it to analyze and improve performance.
SQL Results view shows the result set from executing a SQL file or running a procedural object or ASA function. It also shows operation status details, including any execution plan you can use to improve performance.
You can customize your Database Development perspective by selecting Window|Show View and choosing those additional views that you want displayed.