ClearSQL 6 is a code review and quality control tool for Oracle PL/SQL. With ClearSQL's code review feature you get recommendations for better coding style and check for error-prone places in your project.

ClearSQL 6 generates a series of industry standard quality control metrics about PL/SQL source code to help you to identify potential problems in the development and maintenance of your software and to fine-tune your software development process.

ClearSQL 6 creates and visualizes “clickable” flowcharts and call tree diagrams and CRUD matrices of PL/SQL code that help you find the point of possible code refactoring or module restructuring, discover data flows between subroutines and dataset objects due to DML statement execution, and analyze the consistency of functional requirements and to identify performance problems.

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

• Improve the readability of code
• No manual re-formatting of programs for readability
• Standardize code from other organizations easily
• Improved presentation

• 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
• Automatically fix 9 of the analyzer's rules, accelerating code development

• Determine and report the complexity of the system
• Generate a set of quality control code metrics to identify potential problem areas based on complexity, size and modularity
• Keep your software reliable, testable and manageable

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

• 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

• Import Oracle forms and PL/SQL libraries versions 6 – 10
• 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

• Displays important PL/SQL project (can be thousands of scripts) analysis information in one “Summary” page (dashboard);
• The project content and analysis data that is shown graphically in 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: move, hide, collapse and maximize any individual information pane.
• Export “summary” to a HTML file or print it out

• 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, Diagrams, Alerts, Code and Cyclomatic Complexity in one “Analysis History” page
• Compares the neighbor snapshot values and graphically indicates the 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 on a project or script level in separate tabs
• Export analysis history content to HTML or CSV formats

• Analyze complex and large PL/SQL projects, which usually require hours for analysis during non-working hours, by using integrated scheduled jobs
• Create a job for analysis of an existing project or a selection of online database 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
• Save a job as a Windows command (batch) file and start its execution using a third party scheduler software or run it manually via the Windows command line interface
• 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

• 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 tries and CRUD matrices
• Discover script status and attributes (autofix, code review, crud1, call tree, flowchart)  on the fly
• Syntax-highlighting and code folding editor supports SQL and PL/SQL code
• Generate detailed, easy to navigate and flexibly configured HTML reports for ClearSQL projects
• 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
• Log 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 6 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 menus throughout the program
• Advanced clipboard functions easily accessed with tool buttons
• Toolbar access to the most commonly used commands
• Tools to convert text into Comments and vice versa
• Auto Save option: saving work is guaranteed