ZPA

An open source parser and code analyzer for PL/SQL and Oracle SQL code.

What is this?

The Z PL/SQL Analyzer (or simply ZPA) is a code analyzer for PL/SQL and Oracle SQL code and it's available as a plugin for SonarQube on-premise instances.

NewYou can use the new ZPA CLI to analyze your code and report the issues to SonarCloud.

Features

Bug detection

More than 50 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.

Speed

Up to 9x faster than the commercial SonarQube plugin.

Examples

ZPA CLI

NewZPA CLI is a command-line interface to Z PL/SQL Analyzer. It allows you to run all the checks without a SonarQube installation.