Oracle Query Window Menu Options

To access the following commands, right-click within Oracle Query Window and select from the menu that appears. Where noted, you can access some commands from the Query Toolbar at the top of the Oracle Query Window.

Menu Option	Description
Set AutoCommit Mode	Enables or disables the autocommit mode in the query window.
Set Query Output	Configures the output format or destination to either grid or text format.
Explain Plan	Displays the execution plan for the query commands shown in the Query Editor. If no text is selected, the last query entered into the Query Editor is executed. Any selected text is used as the query text.
Execute Query	Executes the query commands shown in the Query Editor. If no text is selected, the last query entered into the Query Editor is executed. Any selected text is used as the query text. The Execute Query command also appear in the Query Toolbar.
Toggle Query Output	Toggles the display of the Query Output pane. The Toggle Query Output command also appears in the Query Toolbar.
Cancel Query	Cancels the query being executed. This cancels SQL execution, SQL Tuning, as well the Explain Plan feature. The Cancel Query command also appear in the Query Toolbar.
Commit	Commits all DML statements executed since the last commit was issued.
Rollback	Rolls back all changes made using DML statements since the last commit was issued.
Tune SQL	Launches Tune SQL Advisor.
Launch MS Query Designer	Launches Microsoft Query Designer.
Select All	Selects all text in the Query Editor.
Clear All	Clears all text in the Query Editor.
Execute and Monitor SQL	Executes the statement and then opens Real-Time SQL Monitor Window to allow you to monitor the performance. See About Real-Time SQL Monitor.
Rebuild IntelliSense Data	Rebuilds the IntelliSense metadata cache. Use this if database objects have recently been modified.
Cut	Cuts the selected text.
Copy	Copies the selected text.
Paste	Pastes the copied or cut text to the location of the cursor.

In the Text Query Output window, you can right-click to display a menu with the following commands:

Menu Option	Description
Copy	Copies the selected text.
Select All	Selects all the text in the output window.
Clear All	Clears all the text in the output window.

When Oracle Query Window is selected, you can use the following Oracle Query Window-specific commands from the Visual Studio File menu:

Menu Option	Description
Open	Lets you open an existing `.sql` script and load it into the Query Editor, replacing the current content. From here, you can edit, save, execute, or print its contents.
Save	Saves the current contents of the Query Editor to a `.sql` file.