SonarPLSQL

SonarSource delivers what is probably the best static code analyzer you can find on the market for PL/SQL. Based on our own PL/SQL compiler front-end, it uses the most advanced techniques (pattern matching, dataflow analysis) to analyze code and find code smells, bugs and security vulnerabilities. As for any product we develop at SonarSource, it was built on the following principles: depth, accuracy and speed.

SonarPLSQL has a great coverage of well-established quality standards. The SonarPLSQL capability is available in Eclipse for developers (SonarLint) as well as throughout the development chain for automated code review with self-hosted SonarQube or on-line SonarCloud.

Samples of Issues Detected
 
Identical operands Identical operands Identical operands
Duplicate condition Duplicate condition Duplicate condition
Duplicate branch Duplicate branch Duplicate branch
ROWNUM with ORDER BY ROWNUM with ORDER BY ROWNUM with ORDER BY
Custom Rules

SonarPLSQL provides the ability to write custom rules.

Use in developer edition

See all editions


Issue Tracker