DPSQLStudio DPSQLStudio Oracle SQL editor tutorial overview

DPSQLStudio — A Tour: Editor, Results Grid & SQL Toolset

TechnoPKG

2026-06-28 📖 2 min read 👁 11 views

A fast, free Oracle SQL client — the five-minute tour

DPSQLStudio is a lightweight Oracle SQL client for Windows: connect with an Instant Client wallet, browse your schema, write and run SQL, and work the results. It’s built directly on the Win32 API — small download, quick start. This post is the tour; later posts go deep on the data tools. Everything here is the live app (v0.1.0 Beta) connected to an Oracle Autonomous database as ADMIN@dpsqltest_high.

The core loop: tree, editor, grid

Three panes do the everyday work. The object tree on the left lists tables, views, procedures, functions, packages, sequences and triggers (with a filter box). The editor has multi-tab, syntax-highlighted SQL. Run a statement and the results grid fills below.

The core layout: object tree, a syntax-highlighted query against BOM_TEST, and the result grid — a bill-of-materials (Finished Bicycle, Frame, Front/Rear Wheel, …) with the row count in the status bar.

Working the grid: sort, stats, drag, export

The results grid is more than a viewer. Click a header to sort; right-click for a column menu to move columns, export, or compute column statistics — count, distinct, min/max, sum and average — without writing an aggregate query:

Column statistics on a result column — instant count, distinct, min, max, sum and average. You can also drag a header into the editor to insert the column name.

The SQL toolset

The Query menu collects the power tools: Execute line or whole script, Run with Parameters, Format SQL, Cycle Case, Explain Plan, Describe, the Visual Query Builder, snippets and SQL history, plus transaction control (Autocommit / Commit / Rollback).

The Query menu — Execute, Format SQL, Explain Plan, Describe, Visual Query Builder, Snippets, SQL History, and Commit/Rollback all in one place.

Describe is the one you’ll reach for constantly — it lays out a table’s columns with type, size, scale and nullability, so you know the shape before you write against it:

Describe on SALES_ORDERS — every column with TYPE, SIZE, SCALE and NULL?, including AMOUNT as NUMBER(12,2).

Notice the title bar throughout: “UNCOMMITTED CHANGES (F6 = Commit, F7 = Rollback).” DPSQLStudio keeps transaction state front and centre, and by default offers to roll back on close — a sensible guard when you’re editing real data.

The rest of the series

From here the series digs into the Data menu: Sheets, VLOOKUP, Pivot and Multi-sort; Hierarchy Explorer and Compare Datasets; image BLOBs and charts; JSON/XML columns; multi-line column editing; and themes & preferences. Each one is shown live on real data.

DPSQLStudio v0.1.0 (Beta) — a free Oracle SQL client for Windows, by Dhiraj Kumar Pathak (technopkg.com). Screenshots are from the live app; demo data is fictional.

Tags: DPSQLStudio Oracle SQL editor tutorial overview

Comments (0)

💬

No comments yet. Be the first to share your thoughts!