ClearDB FREE easily and quickly documents a complete set of 47 schema (tables, views, procedures, functions, packages, etc.) and non-schema (contexts, directories, profiles, users, roles, etc.) object types as well as source code modules (packaged and stand-alone subroutines) for Oracle versions up to 11gR2.
Moreover, each source code module is analyzed for its structure and architecture. A set of quality control metrics about the code is generated to identify possible error prone procedures based on complexity, size and modularity.
It helps to keep PL/SQL code reliable, testable and manageable. Industry accepted complexity measures (McCabe, Halstead and Maintainability Index, MI) are used. The code review module catches over 60 common coding mistakes and gives suggestions for good programming practices. Our PL/SQL Parser supports up to 99% of SQL and PL/SQL documented keywords and reserved words.
ClearDB FREE is the only Oracle database documentation program known to date, which provides PL/SQL code formatting, analyzing and visualizing (Flowcharts and Call Tree diagrams and CRUD1 and CRUD2 type matrices) while at the same time creates database documentation. The primary output format of the database documentation is HTML. In addition to HTML, ClearDB FREE produces documentation in CHM (Microsoft's Compiled HTML Help) format as well.
ClearDB FREE is equivalent to ClearDB 2.5 Documenter (latest published build of it) and includes all of its features.