ClearSQL 7
„Legacy PL/SQL what is it?“Release HistoryCompany Flyer

ClearSQL 7 is a code review and quality control tool for Oracle PL/SQL. Its code review feature gives recommendations for a better coding style and checks for error-prone places in your project.

ClearSQL 7 analyzes thousands of PL/SQL scripts and Oracle Forms PL/SQL with only a few clicks. It provides a quick look at the most important analysis summaries and tracks changes to PL/SQL code and analysis results.

Key Features
Automated code review
  • Catch more bugs earlier in the development and testing cycle
  • Avoid common mistakes
  • Help junior developers learn from their more experienced peers
  • Produce code that is easier to read, understand and maintain
  • Analyze thousands of PL/SQL scripts and Oracle Forms PL/SQL with only a few clicks
  • Automatically fix 9 of the analyzer's rules, accelerating code development
Code Metrics
  • Determine and report the complexity of the system
  • Generate a set of quality control code metrics such as Cyclomatic Complexity, Maintainability Index, Halstead Volume, etc. to identify potential problem areas based on complexity, size and modularity
  • Highlight the flagged (violated) code metrics for quick identinfication of code anomalies
  • Export code metrics to HTML, Excel, XML and CSV formats for further use or processing in third party software
  • Keep your software reliable, testable and manageable
Coding standards enforcement
  • Improve the readability of code
  • No manual reformatting of programs for readability
  • Standardize code from other organizations easily
  • Naming convention as a best practice for enforcing coding standards
  • Improved presentation and readability of code
  • Write pseudocode for high-level description of the key principles of an algorithm
Project analysis summary
  • Displays important PL/SQL project (can be thousands of scripts) analysis information on one Summary page (dashboard)
  • The project content and analysis data that is shown graphically on the Summary tab dramatically speeds up and simplifies understanding of the overall status of the whole project
  • Drill down the project folders and scripts to see a "Summary" on a single or multiple selection (folder or script level)
  • The page content updates automatically on project folder/script selection change if the page is not "locked"
  • Lock the project summary or the specific folder summary to keep it always visible while navigating in the Project Tree
  • The page layout is highly customizable: pre-defined and user-defined groups; move, hide, collapse and maximize any individual information pane
  • Export "summary" to HTML, Excel, XML and CSV formats or print it out
Flowcharts, Call Tree diagrams and CRUD matrices
  • Takes a package or a stand-alone subroutine and makes a set of Flowchart diagrams that visualize the code execution path
  • Creates clickable Call Tree diagrams from any PL/SQL code that are perfect aid for reading and understanding the data flow of legacy code
  • CRUD matrices help analyze the consistency of functional requirements and identify performance problems
  • Exports a single or multiple project Flowcharts and Call Tree diagrams into image (GIF, PNG and JPEG), MS Visio drawing "vdx" and HTML formats with the ability to keep the diagram tree structure in the target Windows folder.
Bi-directional ("source2project" and "project2source") project and linked source synchronization
  • Create a new ClearSQL project with the ability to link project items (script and folders) with original source objects (files and db objects)
  • Import files and db objects to an existing ClearSQL project with the ability to link them
  • The link keeps relationship between the script in the ClearSQL project and the original source object
  • Synchronize the content of the project object against the original source object and vice versa
  • "Refresh" actualizes the content of the project object against the linked source object
  • "Write Back" actualizes the content of the original source object against the project object
Automated project analysis
  • Analyze complex and large PL/SQL projects, which usually takes a lot of time during non-working hours, by using integrated scheduled jobs
  • Create a job for analysis of an existing project or embedded ClearSQL project that can be a selection of scripts and/or stored objects
  • Create a single or multiple schedule(s) to trigger job execution at a specific date and time or on a regular daily, weekly, or monthly basis
  • Assign the whole project or individual scripts to a job and customize analysis, GUI, and Code Analyzer options
  • Generate an optional ClearSQL report on project analysis completion
Project Report
  • Generate a detailed, clickable and flexibly configured HTML report for a ClearSQL project
  • Create highly customizable project specific or non-project specific report templates for reuse and faster report generation
  • Filter the report content by Parser Statuses, alerts and diagrams to focus on specific areas of the report
  • Navigate the report by up and down and previous and next page navigation features to easily drill down the report content
  • Enable the Report Observations to highlight the scripts with Parser errors and alerts as well as modified, skipped and never analyzed scripts
  • Automate report generation by scheduling it in ClearSQL’s Job Manager or in a third party scheduler.
Support for PL/SQL of Oracle Forms & Libraries
  • Import Oracle Forms and PL/SQL libraries versions 6 – 11g
  • Hierarchical tree drills down the content of forms/libraries in a native Forms Developer manner
  • Discover forms content elements such as Blocks, Program Units, Triggers and Canvases
  • Graphically draws the look&feel of a form’s canvas and displays the properties of its elements
Project analysis history
  • Tracks changes of the project content and analysis information at a project and script level
  • Each analysis creates a "snapshot" storing a full "picture" about the project content and its script analysis values
  • Displays analysis snapshots values grouped by categories such as General, Alerts, Cyclomatic Complexity, Maintainability Index, Halstead Volume, Interface Complexity, Code and Diagrams on one Analysis History page
  • Compares the neighbor snapshot values and graphically indicates a negative or positive direction of the value change
  • Select one or more project content or analysis categories to draw diagrams of changes of their values in a specified historical period
  • Filter a number of shown analysis snapshots by selecting a predefined time frame or date interval or the last "N" snapshots
  • Investigate analysis snapshots at a project or script level on separate tabs
  • Project Analysis History Report exposes the complete project analysis information for each analysis separately
  • Export analysis history content to HTML, Excel, XML or CSV formats
ClearSQL Integrated and Oracle Preprocessor
  • Include debug code in your PL/SQL code and exclude it from production
  • Write code that is portable across multiple Oracle Server versions
  • Maintain a module that can be used by different clients
  • User-defined and substitution variables create command files that allow end-user input
  • Instrumented code insertion locates bugs quickly
  • Support for Oracle Conditional Compilation directives
  • Both Preprocessor directives can be used in code simultaneously
Powerful and Intuitive Graphical User Interface
  • Compact program loads quickly so your code is always at your fingertips
  • Easy-to-use Explorer-like interface
  • Hierarchical tree view for organizing scripts
  • Separate view for the project and script level Analysis Data, Flowcharts, Call Trees and CRUD matrices
  • Discover script status and attributes (Autofix, Code Review, flagged Code Metrics, Pseudocode, CRUD matrices, Call Tree diagrams, Flowcharts) on the fly
  • Syntax-highlighting and code folding editor supports SQL and PL/SQL code
  • Search for text in the project by Occurrence, Regular Expression and Wildcard methods
  • Create new projects based on files and db objects with a few clicks
  • Export and Import a project with its contents as a flat zipped file with an ability to send it by email
  • Active workspace enables full-blown customization of the position, size and visibility of GUI elements
  • User-customized SQL code templates
  • Multiple script versions for easy change tracking and retrieval
  • Logs on to a database by using TNS, LDAP and Direct type connections and remembers last connections
  • Drag-and-drop function throughout the system
  • Easily search your code for keywords through the tree or through separate scripts
  • Regular expressions for describing string matching patterns
  • Export code fragments as text files that can be executed later using any client/server program that reads text files
  • Communicate with Technical Support and keep ClearSQL 7 up to date with its auto update feature
  • Import code fragments as text files or use the drag-and-drop function
  • Easily customize the visibility and position of toolbar buttons of any application toolbar
  • Right-click pop-up menus throughout the program
  • Advanced clipboard functions easily accessed with tool buttons
  • Toolbar access to the most commonly used features
  • Tools to convert text into Comments and vice versa
  • Auto Save option: saving work is guaranteed