Any Static Code Analysis Tools for Stored Procedures?
Solution 1
For T-SQL, Microsoft has the database edition of VS Team Suite (although, I believe its now in the dev SKU). This link talks about writing your own static code analysis rule for T-SQL: http://blogs.msdn.com/gertd/archive/2009/01/01/creating-t-sql-static-code-analysis-rules.aspx
Solution 2
Oracle has some little-known stuff built in.
Try this in 10g Release 2 or above:
ALTER SESSION PLSQL_WARNINGS = 'ENABLE:ALL';
Then compile your PL/SQL package (not an anonymous block).
Solution 3
Toad features the CodeXpert utility to statically check your PL/SQL code.
The utility can either scan files or connect directly to the Oracle database. As far as I've seen, works only on Windows.
Solution 4
Try free Sql Code Guard. It provides fast and comprehensive static analysis for T-Sql code, shows code complexity and objects dependencies
Solution 5
Our SD Source Code Search Engine is a tool for interactively searching large source code bases in many computer languages (including PL/SQL) efficiently, by preindexing the source code files by their tokens (identifiers, numbers, etc). As a side effect of the preindexing step, it computes standard metrics: SLOC, Cyclomatic, Halstead, ... for each file and produces a report. See the site for an example.
Our SD CloneDR is a tool for analyzing large code bases for redundant code. We've applied it to PL/SQL, and have seen something like 45% of the code involved in clones. YMMV. The CloneDR works with a large variet of langauges; see the site for sample clone detection runs on some of those other langauges.
EDIT 10/4/2010:
Our Source Code Search Engine is designed to enable very fast searches across large codes of mixed languages. It succeeds by preindexing the source code. As a side effect of the indexing step, it compute a variety of metrics including Cyclomatic and Halstead measures of complexity.
Just added: not a static analysis tool, but one generally of interest to people interested software quality: our TestCoverage for PLSQL stored procedures.
abu abu
Software Engineering Consultant with experience in identifying, evaluating and recommending Practices, Methods & Tools to build better, faster and cheaper software.
Updated on June 06, 2022Comments
-
abu abu about 2 years
Are there any static code analysis tools for stored procedures written particularly in PL/SQL and T-SQL?
-
abu abu over 15 years
-
abu abu over 15 yearsI would accept this answer as well. Its just that becuase my question has two parts (one for PLSQL and other for TSQL) there are two separate answers but stackoverflow allows only one to be accepted.
-
Ira Baxter over 13 yearsSo one has to have another engine that can handle PL/SQL. See semanticdesigns.com/Products/LanguageTools/PLSQLTools.html