When you execute a script that contains more than one SELECT query, the results of each query are displayed in separate result windows. By default, these windows are called "Result1", "Result2", etc. Using targets, you can specify more meaningful names for query result windows.
•The Show multiple results stacked option must be switched off.
•Select either "Semicolons" or "SQL Grammar" in the Group statements for execution with drop-down list in the Properties window. Otherwise, the query is still executed, but the results are displayed in unnamed result tabs.
1.Place the cursor anywhere in the SELECT statement. Click the Current statement button (Shift+Alt+Enter) in the SQL Editor window. This selects the entire statement.
2.Click the Define Target Name button in the SQL Script toolbar. The text -- target: Result appears above the statement.
3.Change the text "Result" as desired.
4.In the Properties window, make sure that either "Semicolons" or "SQL Grammar" is selected in the Group statements for execution with drop-down list.
5.Click the Execute button or press F5.
The results appear in a Result window that has a tab with the text that you specified as target, e.g., zookeepers.