Analyze, Illustrate, Fix & Run PL/SQL

Unfamiliar PL/SQL code? Analyze thousands of PL/SQL scripts with a single click. Create „clickable” Flowcharts, Call Tree diagrams and CRUD matrices to quickly understand the flow and the logic of the 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

A unique Oracle database documenter generating complete and detailed documentation of Oracle databases up to 12c. It documents 59 database object types, their status and dependencies, the structure and source code modules. In depth analysis and illustration of the database and PL/SQL is provided. The illustration includes ER and R&D diagrams as well as Flowcharts, Call Tree, and CRUD matrices of PL/SQL code — all „clickable”.

Oracle Development & Administration

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

  • detects code errors, code review rule violations, and other PL/SQL code anomalies
  • creates detailed Code Metrics reports from PL/SQL
  • generates „clickable“ Flowchart and Call Tree diagrams and CRUD matrices
  • checks object naming rules incl. scope & data type definition
  • documents PL/SQL via „clickable“ HTML reports
  • analyzes thousands of PL/SQL scripts and Oracle Forms PL/SQL
  • read more...

White paper:   Legacy PL/SQL — what is it?
  • documents 59 schema and non-schema object types of an Oracle database (versions 9 -> 12c)
  • performs a comprehensive and detailed Security Audit of the Oracle database, checking for over 630 potential security risks
  • detects code errors, code review rule violations, and other PL/SQL code anomalies
  • illustrates an Oracle database as ER and R&D diagrams and its PL/SQL objects as Flowcharts, Call Trees, and CRUD matrices
  • compares two Docus or one Docu with its source (or any other) Oracle database — detailed comparison report
  • checks naming conventions of 59 database object types
  • read more...
  • executes SQL and PL/SQL statements over multiple concurrent database sessions
  • writes, debugs, and executes stored objects
  • develops database objects using visual Object Editors
  • analyzes PL/SQL code and creates Flowcharts and Call Tree diagrams
  • manages sessions and storages and monitors database instances
  • compares DBs, Schemas, and Objects and generates synchronization scripts
  • read more...