Any code quality tool for pl/sql?

Question

Hi, is there any tool, library that can analyze plsql code, like PMD/CheckStyle do for Java ?

Answer 1

Quest's TOAD is a good tool for working with PL/SQL, but it is not free or lightweight. It provides formatting, color support in the editor for keywords, intellisense, and it will also provide analysis tools to rate the code's cyclomatic complexity, best practices, and more.

Answer 2

Check out:

http://www.sqlinform.com/

Tool for re-formatting SQL source with many configurable options. Free online version.

Answer 3

I think that Oracle's SQL Developer might do the trick for you (it is free)

http://www.oracle.com/technology/products/database/sql_developer/index.html

Answer 4

See SD CloneDR. This tool find exact or near-miss duplicated code, regardless of reformatting or renaming of identifiers. Applied to a system of several hundred thousand lines of PLSQL code, it foudn about 15% redundant (e.g., removable) code.