Executing multiple SQL statements

You can execute multiple SQL statements from Interactive SQL as long as each statement ends with a command delimiter. The command delimiter is set with the command_delimiter option, and is a semicolon (;) by default. An alternative to using the semicolon is to enter the separator go on a line by itself, at the beginning of the line. See command_delimiter option [Interactive SQL].

Tip

You can press F9 to execute only the selected text in the SQL Statements pane.

You can press Shift+F9 to execute only the selected statement in the SQL Statements pane and select the next statement for execution.

 Showing multiple result sets
 See also