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 flowcharts PL/SQL code of packages on per-subroutine basis, stand-alone subroutines or anonymous blocks of code. ORACLE 10g2's pre-processor directives are supported.

Key features

Coding standards enforcement

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

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

Metrics

• 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

Preprocessor

• Include debug code in your PL/SQL code and exclude it from the 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

• Locate bugs quickly

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
• Editor with syntax highlighting for ANSI SQL, Oracle SQL&PL/SQL and Java
• Multiple versions of a script.
• User-customized SQL code templates
• Drag-and-drop function throughout the system
• Easily search your code for keywords through the tree or through separate script
• 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
• Import code fragments as text files or using the drag-and-drop function
• 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