The Code Editor opens ready to edit SQL code. You will see the SQL Toolbar (Code Editor SQL) and a blank canvas to write SQL code. If you create / open objects requiring PL/SQL code you will see the PL/SQL Toolbar (Code Editor PL/SQL).
Features | Description | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Standard Editing Functions |
All standard editing functions are available. See:
See also: Some functions are duplicated on the shortcut menu. Right click in the editing pane to open the shortcut menu. | ||||||||||||||||||||||||
Working with objects |
Drag and drop objects from the following SQL Navigator modules into the editing pane. Show the definition of the object at the cursor location:
Describe the object at the current cursor location:
| ||||||||||||||||||||||||
Automated Coding Assistance |
| ||||||||||||||||||||||||
Insert ready made code |
Insert ready made code into the editor.
To manage, create and edit the ready made code, see Code Templates. | ||||||||||||||||||||||||
Drag and drop PL/SQL syntax, SQL functions, column names, and database object names into code using the Code Assistant. | |||||||||||||||||||||||||
Code with multiple SQL statements and PL/SQL blocks |
| ||||||||||||||||||||||||
Execute the SQL query or Compile the PL/SQL code |
Execute the SQL query See: The toolbar: Code Editor SQL.
Compile the PL/SQL code See: Code Editor PL/SQL, PL/SQL Debugger, DBMS_OUTPUT. You can compile a program that is stored in the database. While the program is being edited, use the Save command to compile and store it. Once the program has been modified, you will need to save the program prior to any further usage of the Compile/Rebuild functionality - This is to ensure that the changes in the program have been applied to the database. SQL Navigator displays all syntax and compiler errors in a separate scrollable pane. Click on the error text to show the source code at the source of the error. Double click on the error text to show the error message description, cause and actions as per the Oracle documentation. Also watch for feedback in the Output Window.
Auto Reparse Many features of the Code Editor, including the Code Explorer window, code completion, tool tip display of program arguments, bracket matching, collapse loops/blocks, and others, rely on automatic parsing of the PL/SQL code and internally generating a symbol table. This parsing occurs when the editor first loads the objects, and it also occurs in the background in order to maintain the symbol table as the user edits the code. You can also manually trigger a full reparsing (updating of the internal symbol table) at any time by right-click and select Auto Reparse from the shortcut menu. However, when loading a really large script having this option on will slow down SQL Navigator. Hence, to avoid wasting CPU resources, you should turn this option off when editing large scripts.
Symbols in the gutter margin Symbols in the gutter margin provide a visual indication of the statement’s status.
| ||||||||||||||||||||||||
Look and Feel |
|
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center