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.