What is this?

Z PL/SQL Analyzer is a code analyzer for Oracle PL/SQL and Oracle Forms projects. It's avaliable as a SonarQube plugin. SonarQube is an open platform to manage code quality.

This plugin is completely free and open source. It supports SonarQube 6.7.x and newer.

Features

  • Bug detection

    More than 40 rules to detect bugs and code smells in Oracle SQL, PL/SQL and Oracle Forms code.

  • Metrics

    It feeds SonarQube with many metrics about your code (size, complexity, duplications, etc.).

  • Extensibility

    You can use the full power of the parser to create your own coding rules.

Examples

Detect duplicated implementations in the same IF structure.

Source

Check for incorrect comparisions with '' and NULL.

Source

Find incorrect references to Oracle Forms objects and avoid "Cannot find <object>: Invalid ID" exceptions in runtime.

Source