Unfamiliar PL/SQL code? Analyze thousands of PL/SQL scripts with a single click. Creates "click-able" flowcharts, call tree diagrams and CRUD matrices to quickly understand the flow and the logic of your code. Benefit from code metrics to identify potential risks and to get better insight into your code. ClearSQL is a unique PL/SQL review and quality control tool, a code analyzer, and not a simple code formatter.

Documents 54 Oracle database object types, their statuses and dependencies, and their structure. It performs in depth analysis, formatting and illustration of PL/SQL code and includes all three in the documentation. Illustration includes "click-able" PL/SQL flowcharts, call tree diagrams, code metrics, and CRUD matrices. Database anomalies and parser errors are included as well.

Developers' top choice to write database objects, debug, execute, test and manage SQL & PL/SQL statements. DBAs top choice to analyze, monitor, examine and compare multiple Oracle DB's, schemas and objects. Format, analyze, illustrate and improve the quality of your PL/SQL using the "Code Analyzer Kit" for SQLDetective. It's a powerful and cost effective tool for Oracle development and administration.

Highlights in version 6.5

• supports pseudocode for describing algorithms
• flagged code metrics highlight anomalies in code
• naming rules incl. scope & data type definition
• Project Report with easy navigation and filtering
• read more...
  
  

Highlights in version 3

• compares two sets of documentation
• compares database with documentation
• command line support + integrated scheduler
• extracts database DDL from documentation
• read more...

Options in version 4

• Developer Kit
• DBA Kit
• Code Analyzer Kit
• read more...