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.

New in version 6

• supports PL/SQL in Oracle Forms v6 - v10
• command line + integrated scheduler
• supports pseudocode for describing algorithms
• quickly summarizes 1000s of PL/SQL scripts
• read more...
  
  

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. It also can extract database DDL from documentation to act as a last resort in disaster recovery situations.

New in version 3

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

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.

Options in version 4

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