New: Support for Oracle Forms&PL/SQL libraries versions 6 - 10

ClearSQL 6 support for PL/SQL code of Oracle Forms and PL/SQL libraries versions 6 - 10. Import Oracle forms and PL/SQL libraries into a ClearSQL project and analyze, format, fix and illustrate their PL/SQL code. Drill down the project tree to discover the content of forms&libraries such as Blocks, Program Units, Triggers as well as graphically shown canvases.

New: Project, folder and script level analysis summary

Select the project root node in the Project Tree and take a look at the Summary page to discover the most important analysis information shown graphically as pies, bars and grids at a project level. Drill down the project folders/scripts to see "Summary" at a folder/script level.

The Summary page displays: a number of folders and scripts and their statuses ("OK", "Error"); a number of CRUD, Flowchart and Call Tree diagrams; a total number of lines of code and comments; a total value of cyclomatic complexity as well as groupings by method/class/script; a list of top complex objects; a list of Code Metrics per method and more. The Summary page layout is fully customizable and its contents can be easily exported to HTML or printed out.

New: Project analysis history

ClearSQL 6 tracks changes to the project content and analysis information at project and script levels.

Each analysis creates a new "snapshot" storing a full "picture" about the project contents and script analysis values in categories such as: a number of folders and scripts and their statuses ("OK", "Error", "Skipped"); a number of CRUD, Flowchart and Call Tree diagrams; a number of alerts such as errors, autofixes, etc.; a number of lines of code, comments and blank lines; etc.

The "Analysis History" page displays analysis "snapshots" indicating the negative or positive direction of the value change. Select one or more categories to draw diagrams of changes to analysis values. Analysis history content can be easily exported to HTML or CSV formats.

New: Integrated jobs, schedules and command line interface

ClearSQL 6 automates analysis of ClearSQL projects via its scheduled jobs or third party schedulers or the Windows Command Line.

Create a job for analysis of an existing project or a selection of online database objects and schedule it either in ClearSQL 6 by creating one or more integrated schedules or save the job as a batch file and schedule it in a third party scheduler. Each job is fully customizable in terms of analysis, GUI and Code Analyzer options and allows the generation of a ClearSQL report.

New: Analyzer View splits diagrams and analysis history at project and script levels

The Analyzer View pane is intended for displaying analysis information (code metrics, code review, autofixes, structure view), flowcharts, call-tree diagrams, CRUD matrices and analysis history and gives access to their features.

Flowcharts, call-tree diagrams and analysis history are scalable at project and script levels. For ease of use and for focusing on a specific information layer, the new GUI of Analyze View splits the project and a script diagrams and analysis history into different panes and tabs.

Advanced Script Editor

ClearSQL 6 incorporates a powerful syntax-highlighting and code folding editor that allow you to quickly create and understand SQL and PL/SQL code.

Script Editor includes important editing features such as SQL syntax highlighting, code folding, embedded Code Explorer, smart code completion, dot suggestion and stored object arguments hint by Code Insight, a powerful search engine, convenient bookmarks, upper or lower case character conversion, finding a matching pair, commenting and uncommenting blocks of text, and more.

Rapid code-building tools like Code Explorer, Code Insight and user templates save time, reduce errors and ensure a consistent programming style. A set of advanced Cut, Copy, Paste features will improve the productivity of any programmer by reducing the number of keystrokes required.

Project Diagrams Export Wizard

Project Diagrams Export Wizard is a powerful and easy to use tool designed to export flowcharts and call tree diagrams of the project into image (GIF, PNG and JPEG), MS Visio Drawing "VDX" and HTML formats. You can export a single or a set of diagrams or all diagrams of the project at a time.

Export Project to Project Backup and Import Project from Project Backup

A ClearSQL project is a complex system that consists of a number of files of different formats stored in different Windows folders.
Export Project to Project Backup is a tool designed to export/backup a project with its contents (scripts, diagrams, CRUD matrices) as a compressed single flat file.

Import Project from Project Backup is a tool designed to import a project with its contents (scripts, diagrams, CRUD matrices) from a project backup file created by Export Project to Project Backup back to ClearSQL 6.

Project analysis statistic

All analyses performed on a project with detailed information are stored by the application and displayed on the Statistics tab. The last analysis information of the project is shown on the Last Analysis sub-tab. To see the total analysis information, go to the Totals sub-tab where the first and last analysis date are shown with the total number of performed analyses.

Toolbar Customizer

All application toolbars are customizable, meaning that you may show/hide the toolbar buttons and change their positions. Right-click on the toolbar you want to customize and select Customize the Toolbar to open the Toolbar Customize window. Use customization buttons to show/hide and to change a button's position in the toolbar.

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 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.

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.

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.

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.

ClearSQL 6 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.

ClearSQL 6 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.

Project Scripts 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.

Import Scripts and Stored Objects 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.

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 6 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 6 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.

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 6 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 6 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.

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 6 up-to-date using the auto-update feature.

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.