Code Editor toolbar commands
Depending on the content of the current Code Editor tab, certain buttons will be enabled or disabled.
Command / Description/ New SQL / Open a new SQL statement or script.
/ New Stored Program / Create a new stored program (procedure, function, package, package body, type, type body)
/ Open / Load a file into the editor.
/ Save File / Save the current SQL statement or script.
/ Open Object / Open a selected object from the schema
/ Auto Code Completion / When selected, it will enable smart code completion. When de-selected, it will disable smart code completion. (dot lookup will still be enabled)
/ Split Options / Split the current editor into half either vertically or horizontally
/ Send to Session (SQL Layout) / Send the current/selected SQL script to another session
/ Add Condition (SQL Layout) / Adding where conditions into a SQL statement.
/ Remove Condition (SQL Layout) / Remove all the where conditions in a SQL statement.
/ Updateable (SQL Layout) / When toggled on, execute a SELECT statement and edit the resulting data sheet in the Result sets.
/ Stop on Error (SQL Layout) / When toggled on, stop the execution of an SQL script when an error is encountered during the processing of the script. The Editor lets you fix any errors as you go.
/ Fetch All (SQL Layout) / When toggled on, display results after all rows in a query’s result are fetched.
When toggled off, immediately display only the first N rows needed to fill the Result window.
/ Spool to Screen (SQL Layout) / When toggled on, displays query results under the Spool tab of the Code Editor.
/ Scan Defines (SQL Layout) / Scan the script for substitution variables. Toggle this on when using variables or text that contain the characters , , or = :[bind variables].
/ Echo SQL (new in 6.4) / Echo SQL to spool TAB
/ SQL History (SQL Layout) / Open the SQL History dialog to retrieve a previously executed statement from the current session and put it into the editing window.
/ Expand SQL Pane (SQL Layout) / Maximize the Script window of the Coded Editor
/ Skip to Top (SQL Layout) / Set the execution start point and the cursor to the first statement.
/ Skip to Previous (SQL Layout) / Take the cursor back to the previous SQL statement.
/ Run (SQL Layout) / Start the execution of SQL statements from the current cursor position.
/ Single Step (SQL Layout) / Start execution from the current cursor position and stops when one SQL statement has been executed.
/ Stop (SQL Layout) / Stop the execution of the script at the currently executing SQL statement.
/ Skip to Next (SQL Layout) / Place the execution point on the next executable SQL statement.
/ Skip to Bottom (SQL Layout) / Place the execution point at the last statement in the current script.
/ PL/SQL Debugger / Toggle the PL/SQL Debugger on or off.
/ Abort Debug Session / Stop the debugging process
/ Get Latest Revision / When team coding is in use, gets the latest version of an object or script that is held in the VCS repository.
More about Team Coding
/ Check Out / When team coding is in use, checks out the object or script to the current user.
/ Check In / When team coding is in use, places the current version of the object or script into the database.
/ Undo Checkout / When team coding is in use, reverses a check-out operation, so that the object or script can be modified by another user.
/ SQL Optimizer / SQL Optimizer allows developers to analyze and automatically rewrite inefficient SQL queries while they are being built.
More about SQL Optimizer
/ Explain Plan Tool / Opens the Explain Plan Tool.
More about Explain Plan
/ Search Knowledge Xpert / Formerly the RevealNet Knowledge Base. Visit the Quest web site for up-to-date information.
/ Code Expert / Opens the Code Expert Tool
/ Formatter Tools / Advanced formatting tools.
More about formatting tools