What's a good PL/SQL source code analysis tool?

Question

What's a good PL/SQL source code analysis tool?

Answer 1

Only one I'm aware of is toad

Answer 2

Have you tried setting this before compiling your packages:

ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL';

This will give you warnings about unreachable code, etc.

Answer 3

See the SD CloneDR for PL/SQL for a tool that finds duplicated code across large sets of PL/SQL scripts. It typically finds 10-20% redundant code; removing this code can help lower your maintenance costs.

The site has example clone detection reports for many languages, but not an example for PL/SQL. The tool does exist, though.