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