# Query Worksheet

Execute Oracle SQL and PL/SQL queries and view results in the Query Results panel.

Source: https://www.nexosqlstudio.com/docs/worksheet
Language: en
Type: docs

# 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](https://www.nexosqlstudio.com/databases) · [Connection guides](https://www.nexosqlstudio.com/docs/getting-started)

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](https://www.nexosqlstudio.com/docs/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](https://www.nexosqlstudio.com/docs/snippets).

## Bind Parameters

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

```sql
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.

```plsql
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.