Sobre o ClearSQL

Analisador de PL/SQL, formatador, diagramador e editor.

ClearSQL lets you edit, format and analyze your Oracle PL/SQL code, count metrics and enforce coding standards. ClearSQL is a full-blown code analyzer and editor for legacy code maintenance. It lets you analyze declarations, exceptions and the control flow, remove anomalies, fix and format your PL/SQL automatically and more. With ClearSQL you can flowchart your legacy code to discover logic, and visualize the conditional branches, loops and jumps, in order to see the visual patterns of your code. You can also generate call tree diagrams and CRUD matrices to discover data flows between subroutines and datasets to identify performance problems.

ClearSQL Features

  • Improve your code and skills - A preset of over 180 rules checks PL/SQL against the nastiest bugs and helps you stay in line with the latest code-writing trends.
  • Ensure consistent coding style - Use XPath expressions to set up corporate guidelines. Introduce new teams to the in-house rules with much less effort.
  • Locate code smells - Create interactive visuals to instantly detect areas for refactoring. Figure out the code logic, even working on huge projects.
  • Cut the maintenance costs - Count the price of poor coding decisions, and extend your app's lifetime. Code metrics put the most important numbers at your fingertips.
  • Supercharge your effort - Introduce automation to your code analysis routine to focus on completing tasks that require your exclusive knowledge.
  • Keep it up and running - Put your hands on the latest technology with the full support for Oracle Databases up to 19c and Oracle Forms 6i–11g.