Getting Started with SQL Editor

Learn the basic usage and environment settings of the SQL Editor.

Open SQL Editor

Open the SQL Editor and prepare to write queries.

1

Click SQL Editor Tab

Click "SQL Editor" in the top menu or left panel.

2

Select Connection

Select the database connection to execute queries against.

3

Write & Execute Query

Enter SQL in the editor and press the execute button (or Ctrl/Cmd + Enter).

Toolbar

Execute key functions from the SQL Editor toolbar at the top.

Button	Description
EXECUTE	Execute the SQL statement at the current cursor position
RUN SCRIPT	Execute the entire SQL script in the editor sequentially
CANCEL	Cancel the currently running query
PLAN	View the query execution plan (Explain Plan)
Auto Commit	Toggle auto commit mode on or off
FORMAT	Format SQL. Choose between Format Statement (current statement, Ctrl+Shift+F) and Format All (entire script)
Schema / Database	Select the default schema and database for query execution

Edit Data

Directly edit, add, and delete data in the query result grid.

1

Edit Cell

Click a cell in the result grid to directly modify its value. Modified cells are highlighted in yellow.

2

Add / Duplicate / Delete Row

Use the ADD, DUPLICATE, DELETE buttons in the bottom toolbar to add, duplicate, or delete rows.

3

Preview & Apply Changes

Click PREVIEW CHANGES to review the SQL (UPDATE, INSERT, DELETE) corresponding to the changes (edits/additions/deletions). Use the include schema option to add the schema name to the SQL. Execute directly with EXECUTE or copy with COPY SQL.

4

Discard Changes

Click the DISCARD button to cancel all unapplied changes.

Export Results

Export query results to a file.

Format	Description
CSV	Export as a comma-separated text file
JSON	Export in JSON format
XLSX	Export as an Excel spreadsheet file

Execution History

View the history of previously executed SQL statements. In the history tab, view execution time, SQL statements, and execution results, and reload previous queries back into the editor.