ClearSQL is an automated code review and quality control tool for Oracle PL / SQL. It is a powerfully-simple application to edit, format, analyze, and review PL / SQL scripts, delivering consistent and clean code structure.
Version: 18.104.22.168ClearSQL is a PL / SQL code analyzer with advanced functionality for code review, editing, and formatting, quality control, and system optimization.
License: Free To Try $10.00
Operating System: Windows
It generates interactive visuals and delivers comprehensive analysis reports, outlining flaws in the code syntax and structure. It is a 32- and 64-bit Windows tool supporting Oracle databases up to 18c.
ClearSQL checks code against a set of predefined rules and raises alerts when detects violations. The rules are based on industry standards and best programming practices.
Insignificant mistakes are fixed automatically.
ClearSQL draws diagrams (Flowcharts and Call Trees) and matrices (CRUD) based on relations between code elements, indicating potentially problematic areas and revealing the database structure.
It also creates interactive flowcharts based on code comments, making technical processes easy to understand by other stakeholders.
ClearSQL measures maintainability, complexity, and readability of PL / SQL software. Indicators help spot poor programming practices and outline optimization strategy.
ClearSQL automates code analysis and exports the results into portable formats.
Scheduled to run regularly, automated code reviews are easily integrated into QA sessions from early stages of product development.
ClearSQL provides the interface to import PL / SQL scripts and safely modify them without committing to production as well as track changes made to the code by comparing different versions of same scripts.
Version 22.214.171.124: - Subscription license type: 100.000 lines of code for $10 per month. Every 10.000 lines on top of the plan add $1 to the bill. - Detection of duplicate code - Code quality trend - Technical debt calculation