ClearSQL for Oracle  -  PL/SQL analyzer, formatter and editor

Edit, format and analyze your Oracle PL/SQL code. Count metrics and enforce coding standards. ClearSQL for Oracle is a full-blown code analyzer and editor for legacy code maintenance. Analyze declarations, exceptions and the control flow. Remove anomalies. Fix and format your PL/SQL automatically. Flowchart legacy code to discover the logic, visualize the conditional branches, loops and jumps, in order to see the visual patterns of your code.

Key features

Analyze PL/SQL code
ClearSQL for Oracle performs declaration analysis, DML analysis, cursor analysis, control flow analysis, procedure analysis, exception analysis and module analysis and displays the results in a Structure View, facilitating quick navigation through your code.

Automated code review
Catch bugs early in the development cycle and avoid common mistakes. Produce code that is easy to read, understand and maintain. The nearly 60 code review rules detect the misuse of GOTO, parameter declaration problems, unreferenced parameters, missing or misplaced RETURN, unlabeled END, etc.

Auto fix known PL/SQL problems
ClearSQL for Oracle adds missing END and LOOP labels, defines IN parameters and re-parenthesizes complex operations.

Enforce coding standards
Improve readability and standardize code written by others. Enforce naming standards with regular expressions.

Format your code automatically
Set margins and indentation. Insert blank lines. Apply standard casing to keywords and identifiers. Tidy up procedure headers. Align SQL statements.

Flowchart PL/SQL code
ClearSQL for Oracle takes a package or a stand-alone subroutine and makes a set of flow chart diagrams that visualize the code execution path. Such diagrams show the conditional branches, loops and jumps, thereby helping to understand the opaque logic. The visual patterns help to find the points of possible code refactoring or module restructuring, and make the reasons for high values of Cyclomatic Complexity metrics obvious.

Metrics
Determine the complexity of your system. Identify potential problem areas based on complexity, size and modularity. Available metrics: lines of code (LOC), effective LOC, logical statements LOC, comment lines, blank lines, physical lines, McCabe cyclomatic complexity v(G), number of input parameters, number of return points, interface complexity, functional complexity, Halstead Program Length, Vocabulary, Volume, Difficulty and Effort, and Maintainability Index.

Code editor with syntax highlighting
The editor supports ANSI SQL, Oracle SQL, PL/SQL and Java and allows different versions of the same code. It provides power features such as bookmarks, comment out and uncomment a block of code, auto completion and code templates.

More features

• Auto Save keeps you from losing your work.
• Enhanced Find with regular expressions.
• Pre-processor directives let you generate different versions of the same code and include/exclude debug code.
• Save as CHM lets you export analysis results in a convenient HTML help file.
• Syntax Checker verifies your PL/SQL syntax without executing it on Oracle.
• Import from Database let's you connect to your Oracle database and import your files directly
• Bulk Import/Export allows you to handle large numbers of files in a single process