ClearSQL for Oracle Screenshots

New: Analyzer Progress window

The Analyzer Progress window displays and controls the process flow of project analysis in percentage of completion; specifies the analysis settings; displays detailed information about script parser status such as: OK, Error, Skipped; and script attributes such as: Autofix, Code Review, CRUD1 matrix, Flowchart and Call Tree diagrams and analysis; and matrix/diagram generation flow statistics.

Sub-processes such as flowchart and call tree generation may take a longer than others and depend on the complexity of the source code. The CRUD1, CRUD2, Flowchart and Call Tree check marks located at the button's pane are additional indicators to show which sub-processes will be included in the analysis process.

New: Project Wizard

New Project Wizard provides you with an easy to use and powerful graphical interface for creating new projects. You 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.

New: Project Report Assistant

Project Report Assistant generates a detailed, easy to navigate and flexible to configure HTML report for a ClearSQL project, including parser status, analysis information, flowchart and call tree diagrams, CRUD1 and CRUD2 matrices. The project report is like a snapshot of the current state of the project. The report's interface is similar to the application's interface and includes the Project Tree pane, the Analyzer View pane and the optional Parser Status Legend pane.

New: CRUD1 and CRUD2 type matrices

The CRUD tab displays CRUD1 and CRUD2 type matrices generated by internal Parser (Code Analyzer) during analysis. The CRUD tab is applicable to and enabled only for scripts with parser status OK or Modified.

A CRUD (Create, Read, Update, Delete) matrix perfectly aids to analyze the consistency of functional requirements and to identify performance problems. CRUD incorporates two matrix types: "Script Level" CRUD1 type matrix and "Project Level" CRUD2 type matrix to illustrate the relationships between processes and the data they use. Matrices belonging to the script selected in the Project Tree are shown on the CRUD1 tab and are called "Script Level" matrices, while matrices belonging to the whole project are shown on the CRUD2 tab and are called "Project Level" matrices. Both CRUD matrix types are fully clickable.

New: clickable CRUD and Call Tree diagram

Clicking on a data element within a "Matrix 1: Data Object" or a "Matrix 2: Data Object / Stored Object" 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.

Remark: "clickable" = loads the source code and highlights the relevant line of code.

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: export project scripts with Export Wizard

Export Wizard exports project scripts with a variety options into the file system as files. You can export a single script, a set of scripts, or all scripts of the project at a time.

New: import files and db objects with Import Wizard

Import Wizard imports files with a variety options from the file system and/or Oracle database stored objects as project scripts into a ClearSQL project. You 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 the project with a few clicks.

New: comfortable processing of suggested "Autofixes"

The Code Audit | Autofix tab displays autofixes (best practice recommendations that can be automatically fixed to improve code readability) detected by the internal Parser (Code Analyzer) during analysis. The Code Audit tab is applicable to and is enabled only for scripts with parser status OK or Modified.

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
"OK -> Autofix". Such minor code deficiencies are easily fixed, making your code clean and easier to read.

The Code Audit | Code Review tab displays code review items detected by internal Parser (Code Analyzer) during analysis. The Code Audit tab is applicable and enabled only for scripts with parser status OK or Modified.

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.

The Code Metrics tab displays the results of code metrics calculations grouped by subroutines. The list is populated by the internal Parser (Code Analyzer) during analysis and is applicable to and enabled for scripts with parser status OK or Modified.

Software metrics are measures that are used to quantify software and to identify areas of code that can potentially cause problems or errors before software is released. These areas include items that are directly measurable, such as lines of code (LOC), as well as items that are calculated from measurements, such as source lines of code per staff-hour.

The Errors tab displays a list of syntax errors of the selected in the Project Tree script with status Error detected by the internal Parser (Code Analyzer) during analysis or syntax checking. Clicking on an error line highlights the corresponding error line in the Script Editor.

If the script's status is OK, then its code is syntactically correct from the internal Parser's point of view and in that case, the list shows Parser status: OK - no errors in the center of the list.

New: filter, sort and view properties in Project Tree Manager

The Project Tree Manager is located under the Project Tree, is divided by a horizontal splitter, and is designed for managing the Project Tree: filtering and sorting the project items by a variety of predefined filters and sorting rules; as well as for displaying the properties of the selected item and the legend. The colored background of the Project Tree indicates that the tree is filtered. Filtering is possible by parser status and/or script/file names.

The Structure View tab displays the structure of code hierarchically in the tree grouped by categories such as: Declaration Analysis, DML Analysis, Cursor Analysis, Flow of Control Analysis, etc. The tree is built by the internal Parser (Code Analyzer) during analysis and is applicable to and enabled for scripts with parser status OK or Modified. Clicking on an item in the list highlights the corresponding line of code in the Script Editor.

It can be very time-consuming to locate desired program objects (constant declarations, etc.) or certain program constructs (say, CASE statements) when your package body is relatively large. The Structure View can dramatically simplify the task of navigation through your code. In addition to the quick navigation service, the Structure View helps evaluate the quantitative data of your code - the number of certain language constructs, the nesting level of LOOPs and IFs, etc.

Unlike traditional Explorer type organizers, ClearSQL for Oracle 5.0 can retain multiple versions of each script for easy retrieval. For example, assume that you open an existing script as a template for a new project you are working on. The application allows you to create a new version of this script with a few simple clicks and creates a new version automatically to embed instrumented code. After making your changes, you can save the script without losing the original version.

Instrumented Code is a powerful feature of ClearSQL for Oracle 5.0 that locates and identifies bugs in code on the Package, Subroutine and Line of Code levels by adding trace statements bracketed with a pair of conditional directives. Instrumented code entries of stored objects are populated during script analysis and are shown hierarchically on the Instrumented Code tab of the Analyzer View pane for the selected script in the Project Tree.

Find in Project is a handy feature that lets you search any text occurrence in scripts and project tree nodes. The project search result is shown on a new Search tab that appears in the Analyzer View pane on search completion.

New: Online Support Desk

Online Support Desk provides you with an easy-to-use graphical interface to communicate with Technical Support, receive news from Conquest Software Solutions and keep ClearSQL for Oracle up-to-date using the auto-update feature.

New: Diagrams and matrices options in Code Analyzer Options

The Code Analyzer Options window provides an easy interface to the Code Analyzer settings that are grouped by features and are displayed in the navigation tree. There is a group of settings in the Formatter Options page to tune the PL/SQL Formatter. Code Review Options, Code Metrics Options, Flowchart and Call Tree diagrams and CRUD matrix options are available in the appropriate pages.