Advanced Oracle database documenter. ClearDB Documenter easily and quickly documents a complete set of 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.
PL/SQL analyzer, formatter, diagrammer and editor. ClearSQL lets you edit, format and analyze your Oracle PL/SQL code, count metrics and enforce coding standards. ClearSQL is a full-blown code analyzer and editor for legacy code maintenance. It lets you analyze declarations, exceptions and the control flow, remove anomalies, fix and format your PL/SQL automatically and more. With ClearSQL you can flowchart your legacy code to discover logic, and visualize the conditional branches, loops and jumps, in order to see the visual patterns of your code. You can also generate call tree diagrams and CRUD matrices to discover data flows between subroutines and datasets to identify performance problems.
Oracle development and database admin. SQLDetective is a powerful ,easy-to-use graphic user interface for Oracle databases. It can be used to develop database objects; write and debug stored programs, object types and triggers; execute, analyze and format SQL and PL/SQL statements; administer and monitor databases; compare databases/schemas/objects in the same or different databases, as well as browse and modify data and analyze dependencies between objects.