Query Worksheet

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.

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)

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.