Version 4.4

https://trivadis.github.io/plsql-and-sql-coding-guidelines/v4.4/
PLSQL-and-SQL-Coding-Guidelines.pdf

Items marked with a 👮 require a change in the Linter tool suite db* CODECOP (besides including the changed guideline texts).

New

• #210 Highlight the lines that violate a guideline in the bad examples (and the fixed lines in the good examples)
• #212 New guidelineG-3330: Avoid autonomous transactions. 👮
• #213 New guidelineG-4387: Never use a FOR LOOP for a query that should return not more than one row.

Changed

• #208 Include column alias in the title ofG-3182
  • old: G-3182: Always specify column names instead of positional references in GROUP BY clauses.
  • new: G-3182: Always specify column names/aliases instead of positional references in GROUP BY clauses.

Fixed

• #205 Fix revision history in about page