PL/SQL Cop v2.2.0

• Released on 2019-04-04
• Fixed
  • Guidelines
    • G-3120 – false positive when using constants in projection.
    • G-4140 – false positive when using FORALL statement.
    • G-7110 – false positive when using functions/procedures with a single parameter.
  • PL/SQL grammar
    • Parse error when using PRAGMA INLINE with a second string parameter.
• Changed
  • PL/SQL grammar
    • Support keyword EXCLUDE, e.g. as procedure name.
    • Support keyword INSTANTIABLE, e.g. as column name.
    • Support quote literal character / (see also Parser Limitations)
  • SQL*Plus grammar
    • Support $ as alias for HOST command.
  • Support registered extensions (sql, prc, fnc, pks, pkb, trg, vw, tps, tbp, plb, pls, rcv, spc, typ, aqt, aqp, ctx, dbl, tab, dim, snp, con, collt, seq, syn, grt, sp, spb, sps, pck) in upper case. However, default filter is still in lower case.
  • HTML report refers to the Trivadis PL/SQL & SQL Coding Guidelines Version 3.3 hosted on GitHub.
  • Included preview/trial license is valid thru 2019-09-30