Executing SQL Statements


In the Data perspective, there are two ways to execute SQL statements. The first is to use the Query view, and type in a quick statement to be executed. The Query view text area can hold multiple lines, so you can enter complex statements, or even several statements at once. Each statement must end with a semicolon. The results of the query will be shown below in a Result window.


Figure 1.1

The second way to execute SQL statements is to use the Execute SQL context menu command, which is available when right-clicking on .sql files. This command will execute the entire contents of the file, and display the results.


Figure 1.2