There are several ways to execute a SQL file.
To execute a SQL file from the context menu inside SQL Editor:
Open a SQL file from the WorkSpace Navigator project folder in which it is stored.
If the SQL file is not attached to a connection profile, select Attach Connection Profile from the context menu to attach to the associated database.
Select Execute All. SQL Results view displays the result sets, database server messages, execution status (success or failure) and operation details.
To execute a SQL file from WorkSpace Navigator:
Right-click the SQL file name and select Execute SQL File from the context menu. The SQL file executes, and results appear in SQL Results view.
To execute a SQL file from the toolbar:
From WorkSpace Navigator, choose a SQL file from a project folder to execute.
Press the
button on the toolbar. The Choose a .sql File to Execute dialog appears.
Select the SQL file you want to execute from the file system and click Open. The Select Profile for the Editor dialog opens.
Choose the Database Connection Profile type and name.
Click OK.
Execution results appear in SQL Results view.