Auto Code Completion
Scenario: Use Point-And-Click to insert column names for a database object into your code.
- Ensure Auto Code Completion is turned on.
- Place the cursor in the editor window where you want the column names to be inserted.
- Type the name of the object followed by a period mark (.).
- Select the name of the column you want to insert from the drop-down list.
- Press Enter.
Scenario: Show a parameters list for a procedure or function.
- Ensure Auto Code Completion is turned on.
-
Type in the name of the procedure or function followed by an open bracket '('.
-
Automatic code completion brings up a list of parameters (including alternative lists for overloaded procs/funcs).
Scenario: Dot lookup for record members.
- Ensure Auto Code Completion is turned on.
-
Type in the name of the variable followed by a full stop.
-
SQL Navigator displays a list of matching members. Dot-lookup automatically displays a ‘pick’ list of members of a PL/SQL record, cursor, package or %ROWTYPE record.