ClearSQL for Oracle 5.0 - Screenshots

New:  analyzer progress window

ClearSQL for Oracle 5.0 comes with a powerful improved hierarchical Project Tree that allows easy drilling-down through the project and to the select files (scripts) the user wants to analyze. The process of analysis of selected scripts is displayed in the new "Single/Multiple Script Analysis" window with detailed information such as a number of "Done", "Remaining", "Total" scripts; statuses: "OK", "Error", "Warning", "Skipped". The process of analysis can be paused/resumed or fully interrupted and stopped.

WARNING - this parser status indicates the code is OK and can be executed in Oracle, but some issues have been identified by the parser for improvement to a better and correct coding standard.

SKIPPED - scripts/files which are wrapped, DDL's or unknown code are skipped during an analysis.

New:  comfortable processing of suggested AUTOFIXES

ClearSQL for Oracle 5.0 detects missing END and LOOP labels, defines IN parameters, re-parenthesizes complex operations and marks such objects in the Project Tree with
status "Warning".

New features in ClearSQL for Oracle 5.0 provide a very comfortable new way to filter WARNINGS and process suggested AUTOFIXES step by step. Such minor code deficiencies are easily fixed, making your code clean and easier to read.

New:  ClearSQL for Oracle 5.0 will provide more types of "Parser Statuses". e.g. WARNINGS, NEW, MODIFIED, SKIPPED. A new FILTER or SORT feature allows for very powerful and comfortable handling of items in the Project Tree . The colored background of the Project Tree indicates that the tree is filtered. Filtering is possible by parser status and/or script/file names.

ClearSQL for Oracle 5.0 catches bugs early in the development cycle and helps the user to avoid common mistakes and to produce code that is easy to read, understand and maintain. The nearly 60 code review rules detect the misuse of GOTO, parameter declaration problems, unreferenced parameters, missing or misplaced RETURN, unlabelled END, etc. Click on any element within a list and the relevant line of PL/SQL code will be highlighted in the code editor.

New:  CRUD matrix

The CRUD tab displays a CRUD matrix generated for the selected object in the Project Tree. The CRUD (CREATE, READ, UPDATE, DELETE) matrix is a perfect aid for the user to analyze the consistency of functional requirements and to identify performance problems. Clicking on a process element within a "Data/ Process/ CRUD" matrix highlights the relevant line of PL/SQL code in the code editor. In addition if the user clicks on one of the DATA links in a CRUD table,
ClearSQL for Oracle 5.0 automatically displays the related Call Tree diagram next to
the CRUD matrix.

New:  clickable CRUD and Call Tree diagram

Clicking on a data element within a "Data/ CRUD" or a "Data/ Process/ CRUD" matrix generates a Call Tree diagram for this element and displays it in a floating panel divided by a vertical splitter.

There are easy ways for the user to individually adjust the color settings for CRUD and Call Tree diagrams, to print a single CRUD matrix or to print all CRUD matrices of the whole project as well to customize the caption style for a CRUD matrix.

New:  clickable Flowcharts

ClearSQL for Oracle 5.0 takes a package or a stand-alone subroutine and makes a set of Flowchart diagrams that visualize the code execution path. Such diagrams show the conditional branches, loops and jumps, thereby helping to understand the opaque logic. The visual patterns help to find the points of possible code refactoring or module restructuring, and make the reasons for high values of Cyclomatic Complexity metrics obvious.

Clicking on an element of the flowchart loads the related script into the editor and highlights the relevant line of PL/SQL code.

New:  clickable Call Tree diagrams

ClearSQL for Oracle 5.0 creates clickable Call Tree diagrams from any PL/SQL code. A PL/SQL Call Tree diagram is a perfect aid to reading and understanding the data flow of legacy code. Click on any element within a diagram, and the related file of code will automatically be loaded and the relevant line of PL/SQL code will be highlighted in the code editor.

New:  New Project Wizard
    - import files/scripts
    - import objects from an Oracle database into new or existing projects

The New Project Wizard provides the user with an easy to use and powerful graphical interface for creating new projects. The user can add files from any storage device or add database objects directly from any Oracle database. Its handy hierarchical tree allows the user to select any file from any folder/storage/database and add it to a new project with a few clicks.

The same kind of Wizard is used to import files/scripts or database objects into existing projects.