PL/SQL Cop checks compliance with programming guidelines and determines key software metrics that provide information on the quality of their PL/SQL codes, such as MCCabe’s cyclomatic complexity or the Halstead complexity measures. Based on this information, you receive clear statements about the quality of your source codes as well as recommendations regarding quality assurance measures. You can identify errors and misdevelopments at an early stage and thus shorten your development cycles.
PL/SQL Cop in a nutshell
You can make PL/SQL Cop available to individual developers in their development environments, integrate it in your build management tools, or extend your static code analysis tools. PL/SQL Cop is based on the Trivadis PL/SQL & SQL coding guidelines, which you can download free of charge from our website.
Integration in SQL Developer
Increase the added value of your team with seamless integration in SQL Developer. The SQL Developer extension checks the contents of the editor window during development work by mouse click and a keyboard shortcut. All the results are presented in tabs displaying any guideline violations, and from where you can navigate to the relevant positions in your code. Further information is displayed in a full report, which can also be used outside of the IDE.
Command line interface
Generate added value by integrating the solution in your automated quality assurance processes. Via the command line interface, you can run PL/SQL Cop as required outside of your development environment, or integrate it in automated processes. All functions are controllable using parameters. Reports can be created in XML, HTML or Excel format.
Enhance the added value by integrating PL/SQL Cop and SonarQube. You can use the SonarQube plugin for PL/SQL Cop to conveniently integrate them in existing environments for analyzing the static code of your (possibly multilingual) projects, and in build management tools such as Apache Maven, Apache Ant or TFS. Policy violations are shown in the SonarQube dashboards, while PL/SQL code metrics are integrated in the SonarQube reports and dashboards. All PL/SQL Cop results can be exported.Download Product Information Download PL/SQL Coding Guidelines