SQL Navigator for Oracle 7.4 - Installation Notes

Auto Code Completion

Scenario: Use Point-And-Click to insert column names for a database object into your code.

1. Ensure Auto Code Completion is turned on.
2. Place the cursor in the editor window where you want the column names to be inserted.
3. Type the name of the object followed by a period mark (.).
4. Select the name of the column you want to insert from the drop-down list.
5. Press Enter.

Scenario: Show a parameters list for a procedure or function.

1. Ensure Auto Code Completion is turned on.

2. Type in the name of the procedure or function followed by an open bracket '('.

3. Automatic code completion brings up a list of parameters (including alternative lists for overloaded procs/funcs).

Scenario: Dot lookup for record members.

1. Ensure Auto Code Completion is turned on.

2. Type in the name of the variable followed by a full stop.

3. 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.