ClearSQL for Oracle Screenshots

ClearSQL for Oracle's user interface is based loosely around 'explorer style' windows components. It allows you to work with a large and diverse collection of code snippets from within a single screen. Familiar 'tree view' components allow developers to browse through their code libraries, easily selecting items for further processing. The right-bottom portion of the screen is a full-featured but easy to use ASCII editor.

This picture shows SQL code BEFORE formatting.

ClearSQL for Oracle is a powerful and flexible tool for formatting PL/SQL code. It straightens spaghetti code, beautifies it, adds readability with consistent indentation, and makes your PL/SQL code presentable by applying customizable formatting styles. The artfully built visual layout of code will reveal and reinforce its logical structure.

This picture shows SQL code AFTER formatting.

New Call Tree diagrams show subroutine calls and called - by information. As PL/SQL is heavily coupled with data, call tree diagram is enriched with data flows between subroutines and database tables due to DML statements execution. Data flows show how subroutines get data from database tables with SELECT INTO statements, and how they put data back with INSERT or UPDATE statements. DELETE statements are also shown.

ClearSQL for Oracle reverse engineers existing code to flowchart diagrams automatically. IF, FOR and WHILE statements, even with BEGIN . . EXCEPTION . . END blocks are visualized in an easy - to - understand format. An optimal visual layout is made automatically.

Code in flowchart diagram nodes can be displayed in full or in shortened form, making diagrams compact and accurate, while remaining intelligible.

Flowchart diagrams can be shaped as UML activity diagrams, with some minor restrictions. They show linear blocks of actions, branches and jumps, but do not show parallel processes, forks or joins. Swimlanes are not supported at the moment.

While formatting code, ClearSQL for Oracle will analyze it for compliance with industry coding standards and display the areas of your code that can be improved – to be more readable and understandable, more maintainable, reusable and robust. This feature greatly reduces the probability of introducing errors into your code and the time spent in code reviews.

Prior to version 4, only a manual analysis routine existed in ClearSQL for Oracle, where each piece of code was analyzed separately. Now ClearSQL for Oracle performs Project analysis as well. Many code chunks (packages, stored procedures) can be grouped together and subsequently analyzed in one analysis cycle.