Skip to content
PL/SQL Cop for SQL Developer
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
images
FAQ.md Fixes #1 - dead links under limitations Jan 15, 2020
README.md

README.md

PL/SQL Cop for SQL Developer

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.6.

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.

Examples

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.

Check

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

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.

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 from here and use the Install From Local File option.

Update Center

Releases

You find all releases and release information here.

Issues

Please file your bug reports, enhancement requests, questions and other support requests within Github's issue tracker.

Frequently Asked Questions

see Frequently Ased Questions.

Further Information

Please find further information about PL/SQL Cop on the Trivadis website.

License

PL/SQL Cop for SQL Developer is licensed under the Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. You may obtain a copy of the License at https://creativecommons.org/licenses/by-nc-nd/3.0/.

CC-BY_NC-ND

You can’t perform that action at this time.