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

ClearSQL for Oracle 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 for Oracle 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.

• 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

• Compact program loads quickly so your code is always at your fingertips
• Easy to use Explorer-like interface
• Hierarchical tree view for organizing scripts
• 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
• 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
• 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 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