Autocompletion & IntelliSense

Nexo SQL Studio provides context-aware completions for Oracle SQL and PL/SQL. The completion engine combines workspace symbols, custom completion metadata, snippets, and online Oracle metadata when a connection is active.

How It Works

Completions are triggered automatically as you type or manually with Ctrl+Space. The engine analyses:

1. Schema objects — tables, views, packages, procedures, and functions from online Oracle metadata.
2. Inline symbols — local variables, cursors, parameters, and type declarations within the current file.
3. Oracle built-ins and keywords — common PL/SQL packages, SQL functions, and language keywords.
4. Package members — after typing a package name and ., you get public members from indexed package metadata.

Package Member Completion

Type a package name followed by . to see all public members:

DBMS_OUTPUT.PUT_LINE(  ← completion + signature help
DBMS_SCHEDULER.CREATE_JOB(  ← all parameters shown inline

When you start a function call, Signature Help activates and highlights the current parameter as you tab through arguments.

Table & Column Completion

After typing a FROM clause, column completions are scoped to the referenced tables:

SELECT e.|   ← suggests: EMPLOYEE_ID, FIRST_NAME, LAST_NAME, …
FROM EMPLOYEES e

Aliases are resolved, so e. offers EMPLOYEES columns and d. offers DEPARTMENTS columns in the same query.

Custom Completion and Snippets

Built-in and custom Snippets appear in the completion list. You can also point nexo-sql-studio.completion.path at a folder containing plsql.completion.json for table and field completions that are not available from a live connection.

Offline Mode

Completions based on workspace PL/SQL files and exported offline DDL are available without a live database connection. See Offline DDL Export for how to generate the local object files.

Configuration

Setting	Default	Description
nexo-sql-studio.intellisense.online.enable	true	Enable online metadata for live SQL documents and worksheets
nexo-sql-studio.intellisense.online.maxObjectsPerConnection	5000	Maximum objects cached per connection
nexo-sql-studio.completion.maxItems	15	Maximum completion items returned
nexo-sql-studio.completion.path	null	Folder containing custom plsql.completion.json
nexo-sql-studio.searchPaths	null	Paths scanned for PL/SQL symbol discovery