The Code Editor opens ready to edit SQL code. The toolbar is appropriate to SQL development. Each of the toolbar icons is described below. In addition, all standard editing functions are available. See For more information, see Edit, Compile And Execute. for more information.
Icon | Tool Tip | Description | ||
---|---|---|---|---|
Back | Navigate between hyperlinked database objects (in the editing pane) and their dependent objects and components. | |||
Forward | ||||
New SQL | Write a single SQL statement or a series of SQL statements in a new editing pane. The toolbar will open for SQL development. | |||
New Stored Object | Create a stored object. Open the New Stored Object Dialog. | |||
Open File |
Open an external file in the Code Editor. An alternative way to open file is to drag and drop a file from Windows Explorer to the SQL Navigator window. | |||
Save to File | Save the contents of the current Code Editor pane to an external file. | |||
Open Object | Locate a stored object using the Select DB Object Dialog and open the object in the editing pane. | |||
Auto Code Completion | Turn On/Off Auto Code Completion. When turned on, the Code Editor matches variables, parameters, procedures and types as you type. | |||
Vertical Split |
Adjust the layout of the editing pane. Select from the options to split the editing pane in half either horizontally or vertically. The content of the editing pane will be visible in both panes. You can scroll the panes independent of each other.
|
Icon | Tool Tip | Description | ||||||
---|---|---|---|---|---|---|---|---|
Send to Session |
Switch to other sessions and continue working within the same window, with the same script. This feature allows you to run the same script against different databases without the need to copy it into another instance of the Code Editor. It also allows you to correct the oversight of opening a file into the wrong session. You can choose from a list of current sessions or start a brand new session.
| |||||||
Add Condition |
Insert Where clause conditions in the SQL script using a graphical interface.
The Value(s) field is shown depending on which Operator has been selected. Use when there is no semicolon (;) in the script. | |||||||
Remove All Conditions | ||||||||
Updateable |
| |||||||
Stop on Error |
Use in conjunction with Execute to End to validate syntax.
| |||||||
Fetch All |
Limit the rows retrieved on execution of the SQL statement:
| |||||||
Spool Screen | Select to capture a log of executed SQL statements in the SQL Query Log (The Spool Tab). | |||||||
Scan Defines/Substitutions |
Turn On/Off Scan Defines/Substitutions Turn on Scan Defines/Substitutions if your script uses variables or text that contain the characters &, &&, or = :[bind variable]. Otherwise, the statements containing the variables will generate an error. | |||||||
Echo SQL | On/Off | |||||||
SQL History |
Show/Hide the Toolbox History If the Toolbox is unpinned, showing History will not make History visible until the Toolbox is shown. | |||||||
Expand SQL Pane | Maximize screen real estate of the SQL pane. | |||||||
Skip to Top |
Execution Control Buttons:
| |||||||
Skip to Previous | ||||||||
Execute to End | ||||||||
Execute Step | ||||||||
Stop | ||||||||
Skip to Next | ||||||||
Skip to Bottom | ||||||||
PL/SQL Debugger |
Show/Hide the Toolbox PL/SQL Debugger If the Toolbox is unpinned, showing the PL/SQL debugger will not make the PL/SQL debugger visible until the Toolbox is shown. | |||||||
Abort Debug Session | For more on debug see PL/SQL Debugger. |
To enable Team Coding see Administer Team Coding.
Icon | Tool Tip | Description | ||||
---|---|---|---|---|---|---|
Get Latest Revision |
Get the latest version of an object or script as it is held in the Version Control repository. The Get Latest Revision command overwrites the version of the object or script in the database, replacing it with the latest version held in the VCS repository. You can use the View Differences Dialog to compare versions before overwriting the object. | |||||
Check Out |
Check out or check in the current object or script. Open: | |||||
Check In | ||||||
Undo Check Out |
Cancel the check-out. You are prompted to confirm that you want to discard any changes you have made and restore the database version of the item as it was prior to check-out.
|
Icon | Tool Tip | Description | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Optimizer | SQL Optimizer | |||||||||||||||||||
Explain Plan | Explain Plan Tool | |||||||||||||||||||
PL/SQL Formatter |
Format PL/SQL, SQL*Forms, Oracle Forms, and SQL*Plus source code.
| |||||||||||||||||||
Knowledge Xpert | Search Knowledge Xpert | |||||||||||||||||||
Code Analysis | Code Analysis |
© ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center