PL/SQL Cop for SQL Developer

 

Version 2.1.3
Last Update 2017-09-22
File size 39.9 MB
Downloads 5,117

Introduction

Trivadis PL/SQL Cop for SQL Developer is a free extension to check an editor content for compliance violations of the Trivadis PL/SQL &  SQL Coding Guidelines Version 3.2.

PL/SQL Cop calculates metrics per PL/SQL unit, such as:

  • McCabe’s cyclomatic complexity
  • Halstead’s volume
  • The maintainability index
  • Lines
  • Commands (SQL*Plus and SQL)
  • Statements (within a PL/SQL unit)
  • etc.

And aggregates them on file level.

The results are presented in an additional tabbed panel. One tab shows all guideline violations to quickly navigate to the corresponding code position. The other tab contains a full HTML report, which also may be opened in your external browser.

Example

Open an Oracle PL/SQL or SQL script in a SQL Developer editor and press Ctrl-Shift-C to check your code against the Trivadis PL/SQL & SQL guidelines.

PL/SQL Cop - Check

Navigate through the issues using the cursor keys to highlight the related code section in the linked editor.

PL/SQL Cop - Issues

Dock the PL/SQL Cop output window on your favorite position within SQL Developer and click on the report tab to reveal some additional metrics. Open the report in an external browser to print or save the report.

PL/SQL Cop - Report

Configure Update Center

Click the “Help” menu and select “Check for Updates…”. Press the “Add” button to register the update center http://update.salvis.com/ . If you have troubles to configure the proxy settings, because your company requires some additional authentication or similar, then I suggest to download PL/SQL Cop for SQL Developer via the “Download” button below and use the “Install From Local File” option.

PL/SQL Cop - Install