Code Editor
SQL Development
The Code Editor opens ready to edit SQL code.
| More Information | Brief Description |
|---|---|
| Code Editor SQL | The Code Editor toolbar in SQL development. |
| Edit, Compile And Execute | Write SQL code. Compile the code. |
| SQL Query Results Data Grid | Browse the results of executed SQL queries. |
| SQL Query Log (The Spool Tab) | View a log of executed SQL statements. Retrieve executed SQL statements. |
PL/SQL Development
The Code Editor layout for PL/SQL development is used when a stored object is opened or is being created.
| More Information | Brief Description |
|---|---|
| Code Editor PL/SQL | The Code Editor toolbar in PL/SQL development. |
| Edit, Compile And Execute | Write PL/SQL code. Compile the code. |
| PL/SQL Execution Console | Set input parameters. Run the PL/SQL program. |
Toolbox
| Icon | More Information | Brief Description |
|---|---|---|
 |
Code Explorer | Show a hierarchical view the code. |
 |
Outline | Show the syntax tree of the current source. |
 |
DB Explorer | Find and open database objects. |
 |
Describe | Show the data structure for tables, indexes, views and synonyms. |
 |
History | Show the most recent successfully executed SELECT, UPDATE, DELETE commands and PL/SQL blocks in the current session. |
 |
Dependencies | Show the Dependants and Depends On objects of the current script. |
 |
Columns | Show/hide columns of the retrieved table in the data grid. |
 |
Tools and features for debugging stored programs. Show/Hide the PL/SQL Debugger in the Toolbox from the Code Editor toolbar. |
|
|
TIP:
|
