ClearSQL for Oracle
| Original author(s) | Conquest Software Solutions |
|---|---|
| Stable release | 6.9
/ December 19, 2016 |
| Engine | |
| Operating system | Windows |
| Type | PL/SQL analyzer, diagrammer, formatter, and editor |
| License | Proprietary |
| Website | www |
Search ClearSQL for Oracle on Amazon.
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.
Main features[edit]
PL/SQL code analysis[edit]
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[edit]
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[edit]
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[edit]
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[edit]
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[edit]
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[edit]
- PL/SQL developers who maintain, fix, modify, or provide support for legacy PL/SQL code
- PL/SQL developers working on projects in which no documentation is available and the original developer is no longer present
- PL/SQL development teams that need to implement coding standards, code quality assurance, and code formatting to facilitate maintenance of their code; and to speed up PL/SQL code development and test cycles
Licensing[edit]
ClearSQL is a licensed software product that is free to try with a no-cost 30-day trial license.
See also[edit]
- SQLDetective
- ClearDB Documenter
- Code audit
- Static program analysis
- List of tools for static code analysis
External links[edit]
- Official ClearSQL website
- Conquest Software Solutions website
- Conquest Software Solutions company flyer
- Legacy PL/SQL - what is it?
This article "ClearSQL for Oracle" is from Wikipedia. The list of its authors can be seen in its historical. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.
