The development and managing of the Oracle-based applications is increasingly getting a more complex and tedious task. ClearDB for Oracle enables you to solve these tasks faster and more efficiently by providing a powerful an easy-to-use interface to create Oracle database documentations.
ClearDB for Oracle documents a complete set of 47 schema and non-schema object types for Oracle up to version 11gR2:
| CLUSTER |
POLICY |
FLASHBACK ARCHIVE |
| CONTEXT |
POLICY GROUP |
MATERIALIZED VIEW |
| DATABASE |
PROCEDURE |
MATERIALIZED VIEW LOG |
| DIRECTORY |
PROFILE |
REFRESH GROUP |
| EDITION |
QUEUE |
RESOURCE CONSUMER GROUP |
| FUNCTION |
ROLE |
RESOURCE PLAN |
| INDEXTYPE |
SEQUENCE |
RESTORE POINT |
| JAVA CLASS |
SYNONYM |
ROLLBACK SEGMENT |
| JAVA SOURCE |
TABLE |
SCHEDULER CHAIN |
| JOB |
TABLESPACE |
SCHEDULER CREDENTIAL |
| LIBRARY |
TRIGGER |
SCHEDULER JOB |
| LINKDIMENSION |
TYPE |
SCHEDULER JOB CLASS |
| OPERATOR |
TYPE BODY |
SCHEDULER PROGRAM |
| OUTLINE |
USER |
SCHEDULER SCHEDULE |
| PACKAGE |
VIEW |
SCHEDULER WINDOW |
| PACKAGE BODY |
|
SCHEDULER WINDOW GROUP |
Additionally, the user may include to documentation PUBLIC SYNONYMs, PUBLIC DATABASE LINKs and RECYCLE BIN objects.
ClearDB for Oracle helps to keep PL/SQL source code of stored objects (procedures, functions, packages, package bodies, object types, object type bodies, triggers) 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. Its PL/SQL Parser supports up to 99% of SQL and PL/SQL keywords and reserved words. A set of quality control metrics about the code is generated to identify possible error prone procedures based on complexity, size and modularity.
Key benefits
- Generates complete and detailed database documentation for any Oracle database; supports
Oracle 7 --> Oracle 11g
- Support for a complete set of 47 schema and non-schema object types for Oracle version up to 11gR2
- Analyzes and documents PL/SQL objects, their statuses and dependencies
- Automated code review reports parser observations (syntax errors, PL/SQL warnings, and more...)
- PL/SQL Parser (Analyzer) supports up to 99% of SQL and PL/SQL keywords and reserved words
- Includes PL/SQL code diagrams (Flowchart, Call Tree, CRUD1, CRDU2) into the database documentation
- Includes Code Metrics information of PL/SQL code
- Includes a "Code Audit" page for each stored object
- Includes a database observation report with Parser and Database errors, alerts and warnings
- Includes a complex report about Database errors or Database anomalies
- Generates documentation in HTML (default format) and CHM formats
- Sends one or a selection of documentation from History by Email, zipped
- Provides with an easy-to-use graphical interface that is based on step-by-step wizard technology
- Online Support Desk dramatically simplifies communication with Technical Support and keeps
the application up-to-date
- Logs on to a database by using TNS, LDAP and Direct connections
Conquest Software Solutions keeps busily working to improve the functionality and quality of ClearDB for Oracle.