Executing a SQL Statement

Execute a SQL statement from an editor.

Prerequisites

Be sure the data server for which you are executing a SQL statement is running, and you created and established a connection to the data server. Open the SQL file or procedural object its associated editor.

Highlight the SQL statements you want to execute.
For procedural objects, open the editor's Source page.

Execute one, multiple, or all SQL statements.

To	Do this
Execute one or more SQL statements	Hightlight the statements and select Execute Selected Text.
Execute all statements	Select Execute All.

Execution status and and results appear in the SQL Results view.