Database Execution Console

This topic provides an overview of the database execution console window.

The Database Execution Console (or DB Execution Console) window is the area where the results of the executed statement/script or program is displayed. This console window is automatically displayed after the execution of a program or code is complete. The following are displayed on the console:

• input parameter(s) and corresponding output
• results in the forms of table records for SQL statements and scripts
• compiler messages
• statement execution messages including success or error messages

Following toolbar options are provided in the DB Execution Console window allowing you to perform various operations in the displayed results:

Toolbar Options	Description
Close	Close the execution console window.
View SQL Statement	Points to the SQL statement corresponding to the line/record in the result that has been run.
View Record	Open the DB Navigator - View record dialog box to view details of a specific record such as the column name, character type, and max character limit.
Edit Method	Applicable for method execution only. Returns the focus on the Program Editor window by enabling the cursor on the line of program.
Open Execution Dialog	Applicable for method execution only. Opens the DB Navigator - Execute Method dialog box and lets you modify the input parameter(s) and target context such as database schema or connection.
Fetch Next Records	If the number of records found in the result exceeds the configured maximum number of records that can be displayed at a time, click this to fetch the next set of result block.
Rerun Statement	Execute the SQL statement again. Applicable for SQL statement results.
Execute Again	Applicable for method execution only. Enables re-execution of the method.
Stop Execution	Applicable for method execution and is only enabled when you select Execute Again option. Enables pausing the execution before it completes.
Find Data	Search for a specific record in the results data by typing matching text or regex keyword.
Export Data	Opens the DB Navigator - Export Data dialog box to export either a selected record or the entire query result to a specified destination in the desired file format.
Expand All	Expand the result block. Applicable for SQL script results.
Collapse All	Collapse the result block. Applicable for SQL script results.
Settings	Access the Execution Engine Settings.

You can change the position, view mode and size of the DB Execution Console window per your preference on the IDE platform to which you have the Oracle® Database Navigator plug-in installed.