ClearSQL for Oracle - PL/SQL analyzer, formatter, diagrammer 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, and visualize the conditional branches, loops and jumps, in order to see the visual patterns of your code.  Generate Call Tree diagrams and CRUD matrices to discover data flows between subroutines and dataset objects due to DML statement execution and consistency of functional requirements and to identify performance problems.

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. Script Parser Status displays the status (New, OK, Error, Skipped and Modified) of the script and for the OK status, its attributes such as: Autofix, Code Review, CRUD1 matrix, Flowchart and Call Tree diagrams.

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.

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 diagrams

ClearSQL for Oracle takes a package or a stand-alone subroutine and makes a set of clickable flowchart 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.

Call Tree diagrams

ClearSQL for Oracle draws subroutine calls and called-by path of PL/SQL code in call tree diagrams. As PL/SQL is heavily coupled with data, the call tree diagram is enriched with data flows between subroutines and database tables due to DML statement execution. Clickable data flows show how subroutines get data from data objects (table, view) with SELECT INTO statements; how they put data back with INSERT or UPDATE statements and how they delete data with DELETE statements.

CRUD matrices

A CRUD (Create, Read, Update, Delete) matrix is the perfect aid to analyze the consistency of functional requirements and to identify performance problems. CRUD incorporates two matrix types: "Script Level" CRUD1 type matrix and "Project Level" CRUD2 type matrix to illustrate the relationships between processes and the data they use. Both CRUD matrix types are fully clickable.

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.

Enforce coding standards

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

Project reports

Generate a detailed, easy to navigate and flexibly configured HTML report for a ClearSQL project including parser status, analysis information, flowchart and call tree diagrams, CRUD1 and CRUD2 matrices.

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 significant features

• New Project Wizard creates ClearSQL projects based on files and db objects easily with a few clicks.
• Import Wizard imports files from the file system and/or Oracle database stored objects as project scripts into a ClearSQL project.
• Export Wizard exports project scripts with a variety of options into the file system as files.
• Project Tree Manager filters and sorts the project scripts by a variety of predefined filters and sorting rules; and also displays script properties and legend.
• Built-in Version Control System manages multiple versions of scripts for easy change tracking and retrieval.
• Pre-processor directives let you generate different versions of the same code and include/exclude debug code.
• Syntax Checker verifies your PL/SQL syntax offline without executing it in Oracle.
• Find in Project lets you search any text occurrence in scripts and project tree nodes.
• Online Support Desk communicates with Conquest Software Solutions Technical Support and keeps ClearSQL up-to-date with its auto-update feature.