Analyze, Illustrate, Fix & Run PL/SQL

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.

 
Advanced Oracle Database Documenter

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.

 
Oracle Development & Administration

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.9

  • bi-directional code synchronization
  • 11 new code review rules - 70 rules in total
  • naming rule patterns for names of object types
  • supports Oracle Conditional Compilation directives
  • 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

 
ClearSQL & ClearDB Documenter - the best to keep your PL/SQL alive and your Oracle DB documented
Products Buy Now Support Company