v0.2.0

Features

• SQL Tools → Copy SQL with constants resolved: put the cursor in a query inside a package, procedure or block (or
  select it) and get a statement that runs on its own in a SQL Window or Explain Plan. PL/SQL constants become their
  values (status = c_new → status = 'NEW' /*c_new*/), variables and parameters become bind variables (:p_id),
  INTO / BULK COLLECT INTO and RETURNING ... INTO are removed. The editor is not changed; the result goes to the
  clipboard.
  • Constants are found like PL/SQL does: enclosing blocks, the package body, its specification, pkg.c_x and
    owner.pkg.c_x; package variables with a plain initial value count too. When the IDE is connected, other packages'
    specifications are read from the database through the IDE's own connection (no other tools needed).
  • A constant whose value is still unknown becomes a bind variable named like it (pkg.c_x → :c_x).
  • Columns, tables, aliases, sequences and function calls are left as they are.
• Context menu: Copy SQL and the everyday commands (IN list, quoting, case, dates) are also in the editor's
  right-click menu.
• Icons on the ribbon buttons.

Internal

• Tested inside real PL/SQL Developer 12, 13, 14, 15, 16 and 17 on every interop change: CI installs each version and
  runs the plug-in self test in it (also available by hand: TextTools selftest in a Command Window).

Install

1. Close PL/SQL Developer (64-bit, version 12 or later; tested on 14).
2. Download PlsqlDevTextTools.dll below and copy it into <PL/SQL Developer>\PlugIns.
   From the zip: unpack, then Unblock-File PlsqlDevTextTools.dll if Windows marked the download.
3. Start the IDE; if the Plug-Ins menu has no Text Tools, enable it in Configure > Plug-Ins.

No .NET runtime is needed: the DLL is compiled with .NET Native AOT.

Verify the download

• Checksums: SHA256SUMS.txt (Get-FileHash PlsqlDevTextTools.dll -Algorithm SHA256).
• Build provenance: gh attestation verify PlsqlDevTextTools.dll -R kivilev/plsql-developer-text-tools.