When an SQL Editor tab is selected, the most important items on the main menu bar are the Query and Edit menus.
SQL Query Menu
The Query menu features the following items:
Execute (All or Selection): Executes all statements in the SQL Query area, or only the selected statements.
Execute Current Statement: Executes the current SQL statement.
Explain (All or Selection): Describes all statements, or the selected statement.
Explain Current Statement: Describes the current statement.
Visual Explain Current Statement: Visually describes the current statement, based on EXPLAIN information provided by MySQL Server 5.6 and above.
Stop: Stops executing the currently running script.
Reconnect to Server: Reconnects to the MySQL server.
New Tab: Creates a duplicate of the current SQL Editor tab.
Commit Transaction: Commits a database transaction.
Rollback Transaction: Rolls back a database transaction.
Refresh: Synchronizes with the live server and refreshes views such as the live Overview tabsheet.
Commit Result Edits: Commits any changes you have made to the server.
Discard Result Edits: Discards any changes you have made.
Export Results: Exports result sets to a file. Selecting this option displays the Export Query Results to File dialog. The dialog enables you to select which result set you wish to export, the file format (CSV, HTML, XML), and the name and location of the output file. Then click Export to export the data.
The Edit menu features the Format submenu. The Format submenu includes the following menu items that are of importance when in SQL Editor mode:
Beautify Query: Reformats the query selected in the query tab and lays it out in nicely indented fashion.
UPCASE Keywords: Converts keywords to uppercase in the currently selected query in the query tab.
lowercase Keywords: Converts keywords to lowercase in the currently selected query in the query tab.
Un/Comment Selection: Comments the lines currently selected in the query tab. If the lines are already commented, this operation removes the comments.
Auto-complete: Triggers the auto-completion wizard. This is enabled (and triggered) by default, and can be disabled with Preferences, SQL Editor, Automatically Start Code Completion. Auto-completion will list functions, keywords, schema names, table names and column names.
Copyright © 2006, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices