Skip to content

v0.3.0

Choose a tag to compare

@github-actions github-actions released this 23 Oct 11:50
· 10 commits to master since this release
19d8c59

Features

  • Format Tools → Apply formatting rules: formatting rules that the IDE's Beautifier cannot express, applied to the
    selection or to the whole text after the Beautifier has run. Everything happens inside the DLL: no external tools, no
    database. The rules: END name; for named subprograms and packages; := aligned in groups; Oracle built-in
    functions and %TYPE / %ROWTYPE in upper case; a blank line before each PROCEDURE and FUNCTION (and its comment)
    but not before the closing END of a package; a long or multi-line EXECUTE IMMEDIATE literal on its own line; no
    trailing blanks. Only layout and case change: the tokens are compared before and after, and if anything else would
    change, the text is left as it was.
  • Format Tools → Settings: a window like the IDE's Beautifier Rules. A tab per group (General, Case, Code, Blank
    lines), a checkbox or a number per rule, and a large preview of a sample with line numbers and colours that follows
    every click. The window can be resized. The settings are saved in %APPDATA%\TextTools\format-rules.json: put the
    file into a repository and copy it to each machine, and the menu command uses it. The window follows the language of
    the IDE.
  • Menu in the language of the IDE: submenu and item captions (Plug-Ins menu, ribbon, editor context menu) follow
    the IDE's translation (Preferences → Language): Brazilian, Chinese, French, German, Hungarian, Japanese, Russian,
    Spanish; English when the IDE has no translation. If a Key Configuration hotkey of a Text Tools item stops working
    after switching the IDE language, bind it again.
  • SQL Tools → Explain Plan with constants: the IDE's own Explain Plan of the statement under the cursor, with
    constants resolved like Copy SQL (bind F5 to it in Key Configuration to replace the built-in one).
  • SQL Tools: no separator line between Copy SQL with constants resolved and Explain Plan with constants.

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.