Query Worksheet

Database support

Database support does not imply identical features. Connections and SQL worksheets are the starting point; editing, DDL, modeling, transfers, administration and AI operations depend on the engine and workflow. Check the installed version and the relevant guide before relying on an advanced operation.

Supported databases and feature availability · Connection guides

The Query Worksheet is where you write and run Oracle SQL and PL/SQL interactively. Results are displayed in the SQL Results panel.

Opening a Worksheet

• Right-click a connection in the Connections Explorer → Open SQL Worksheet
• Command palette → Nexo SQL Studio: Open Worksheet

A new unsaved .sql tab opens connected to your chosen database.

Running Queries

Action	Shortcut
Run current statement	Ctrl+Enter
Run selected text	Select text, then Ctrl+Enter
Run all statements	Ctrl+Shift+Enter

The extension detects statement boundaries (; and /) automatically and executes only the statement under the cursor unless you have a selection.

To create a query from database metadata, open completions with Ctrl+Space and choose select (assisted) or group by (assisted). Nexo guides you through choosing a table and its columns. You can also open Query Builder from a bound worksheet.

Query Results Panel

After execution, results appear in a tabular panel with:

• Column sorting — click any header to sort ascending/descending
• Filtering — narrow rows from the results toolbar
• Pagination — navigate large result sets with the page controls
• Export — export to CSV, JSON, or clipboard from the toolbar
• Row details — click a row to see a vertical key-value breakdown (useful for wide tables)

Search all columns from the toolbar or filter an individual column from its header. Text filters use case-insensitive partial matching by default; wrap a value in single quotes to match it exactly. Click column headers to sort by multiple columns, or hold Ctrl/Cmd while sorting to replace the current order. Select rows before exporting or generating SQL for that selection.

The results panel’s Help menu contains the full results reference. For more ways to write queries, see Snippets.

Bind Parameters

Use :variable_name bind parameters to avoid SQL injection risks when testing parameterised queries:

SELECT * FROM employees WHERE department_id = :dept_id

When the query runs, a dialog appears asking you to supply values for each bind parameter. Values are reused during the current worksheet session.

DBMS_OUTPUT

Any DBMS_OUTPUT.PUT_LINE calls in your PL/SQL blocks are captured and shown with the worksheet output.

BEGIN
  DBMS_OUTPUT.PUT_LINE('Hello from Oracle ' || user);
END;
/

Execution Plan

Use the worksheet actions to inspect execution plans for supported statements. Plans are displayed in the SQL Results panel.

Multi-Connection Queries

Advanced users can run the same query against multiple connections simultaneously using Multi-Connection Query. Results per connection appear in separate tabs.