PL/SQL Cop is a standalone command line utility. It processes SQL*Plus scripts within a directory tree and produces an HTML report and an Excel workbook. It reports metrics on file and PL/SQL unit level as well as violations of the Trivadis PL/SQL & SQL Coding Guidelines Version 3.2.
PL/SQL Cop for SQL Developer is a cost-free extension to Oracle’s SQL Developer 4.x. It processes the content of an editor window and produces a HTML report which is similar to the one of PL/SQL Cop but reduced and adapted to the scope of a single editor window. Additionally the violations of theTrivadis PL/SQL & SQL Coding Guidelines Version 3.2 are presented in a dedicated tab pane linked to the editor window to support quick navigation to the corresponding code.