2020-11-01

Patching SQL Developer 20.2 with SQLcl’s Formatter

Introduction SQLcl 20.3.0 was released on October 29, 2020. It’s the first time I remember that we have a SQLcl version without the corresponding SQL Developer version. This is a pity because this SQLcl version also contains formatter fixes. And formatting code is something I do more often in the full-blown IDE […]
2020-08-28

Formatting SQL Code Blocks in Markdown Files

Introduction Everything Changes. Our Trivadis SQL & PL/SQL Coding Guidelines are no exceptions. We plan to change rule #1 of our coding styles. From “Keywords are written uppercase, names are written in lowercase.”  to “Keywords and names are written in lowercase.“. We have 103 Markdown files and most of them contain several […]
2020-08-09

Formatting SQL Scripts in a Directory Tree with SQLcl

Introduction Oracle’s SQL Developer can format code in any worksheet and PL/SQL editor. The formatter is highly configurable and the default formatting results are becoming better with every version. Oracle’s SQLcl is a command-line tool. It’s a stripped down version of SQL Developer and known as a user-friendly alternative for SQL*Plus. But […]