Operating system Website www.myclearsql.com | License Proprietary | |
Original author(s) Stable release 6.9 / December 19, 2016 (2016-12-19) Type PL/SQL analyzer, diagrammer, formatter, and editor |
ClearSQL for Oracle by Conquest Software Solutions is application software specifically designed for automated code review and quality control of Oracle PL/SQL. ClearSQL helps to easily understand non-documented legacy code, analyzing thousands of PL/SQL scripts for a better coding style, and checks code for error-prone places.
Contents
PL/SQL code analysis
Performs different types of code analysis: declaration, DML, cursor, control flow, procedure, exception, and module analysis. Displays the analysis results in a Structure View, facilitating quick navigation through code.
Automated code review
Helps to catch bugs early in the development cycle and avoid common mistakes. 75 code review rules detect the misuse of GOTO, parameter declaration problems, unreferenced parameters, missing or misplaced RETURN, unlabeled END, etc.
Code metrics
Generates a series of industry standard quality control metrics about PL/SQL source code to help to identify potential problems in the development and maintenance of code.
Calculates four main metrics during analysis – Cyclomatic Complexity (McCabe v(G)), Maintainability Index, Halstead Volume, Interface Complexity – by using in their calculation other metrics such as Lines of Code (LOC), Program Length, Program Vocabulary, Comment Lines, Blank Lines, Functional Complexity, etc.
Code illustrations
Creates and visualizes "clickable" Flowcharts and Call Tree diagrams and CRUD matrices of PL/SQL code that help to find the point of possible code refactoring or module restructuring, discover data flows between subroutines and dataset objects due to DML statement execution, and analyze the consistency of functional requirements and to identify performance problems.
Enforcement of coding standards
Improves readability and standardizes code written by others. Enforces naming standards with regular expressions. Dual template pattern definition mode allows users who are not familiar with the Regular Expression syntax to enter the naming rule pattern in a simple and convenient way; and, for experienced users, it gives the full freedom and power of the Regular Expression syntax.
Support for PL/SQL of Oracle Forms & Libraries
Supports PL/SQL code of Oracle forms versions 6–11. Allows importing Oracle forms and PL/SQL libraries into a ClearSQL project and analyze, format, fix, and illustrate their PL/SQL code.
Who should use ClearSQL and why
Licensing
ClearSQL is a licensed software product that is free to try with a no-cost 30-day trial license.