ClearSQL Specifications
|
Analyze, edit, format, and improve PL/SQL code
ClearSQL is a PL/SQL code analyzer with advanced functionality for code review, editing, and formatting, quality control, and system optimization. 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.