DPSQLStudio — Multi-line Column Insert & Delete

Editing a column down hundreds of lines at once

Sometimes you need to change the same character position across many lines — insert a marker, align a value, or strip a block out of a generated script. Doing it line by line is miserable. DPSQLStudio’s Insert / Delete in Column (Edit menu) applies a column edit across a whole line range in one step — and one undo. Screenshots are from the live app (v0.1.0 Beta) on Oracle as ADMIN@dpsqltest_high.

The setup: a 247-line generated script

Here’s a multi-level Bill-of-Materials script — a CREATE TABLE plus ~240 INSERT INTO bom_components lines (247 lines, ~19 KB). It’s exactly the kind of repetitive, column-aligned text where per-line editing would take forever.

The dialog

Open Edit ▸ Insert in Column. The dialog is column- and line-addressed: From line / To line, From column / To column, a tab width (so columns line up against your editor’s tabs), an Insert / Delete choice, and the Text to use.

Two modes, one dialog. Insert drops the Text in at From column on every line in the range (padding short lines). Delete with empty Text removes the column block From .. To; with Text, it deletes exactly that text where it appears at/after the column.

The result — 200 lines edited in one click

Applying an insert of ZXCD at column 30 for lines 1–200 drops it into the same position on every one of those lines at once. The character count jumps from 19,380 to 20,180 — exactly 4 characters × 200 lines:

The single-undo behaviour is the quiet hero here: a 200-line transformation is one step forward and one step back, so experimenting is safe. (In real use you’d insert an actual value or delete a stray column rather than a placeholder.)

Coming up

Next: the full Data menu tour and Preferences, including the eight editor themes and the light ↔ dark switch.

DPSQLStudio v0.1.0 (Beta) — a free Oracle SQL client for Windows. Screenshots are from the live app; demo data is fictional.

Comments (0)