SQL and PL/SQL File Editor Menu Options

To access the following commands, right-click within the SQL and PL/SQL File Editor and select from the menu that appears. Many of these commands are also available via the toolbar.

Menu Option	Description
Execute	Executes the SQL or PL/SQL on the line containing the cursor. If you highlight multiple lines, it will execute all of them.
Execute All	Executes the entire script file.
Format	Formats the entire file using the SQL and PL/SQL Formatter Settings. If you highlight one or more SQL or PL/SQL statements it will format only those statements.
Rebuild IntelliSense Data	This menu option forces an immediate update of the IntelliSense Data. Use this if database objects have recently been modified. IntelliSense Data is cached when a connection is first established. In certain circumstances some of this data might be automatically updated. See IntelliSense Settings Options Page for more details.
Explain Plan (Grid)	Displays an explain plan in a grid format. See Explain Plan Settings for information on how to customize this plan.
Explain Plan (Text)	Displays an explain plan in a text format. See Explain Plan Settings for information on how to customize this plan.
SQL and PL/SQL Formatter Settings	Opens the SQL and PL/SQL Formatter Settings which controls how formatting will be done.
Disconnect Connection	Disconnects the editor from the database connection. The editor can be reassociated with a connection by using the connection dropdown in the editor toolbar.
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.