A professional touch
for every line.
A pro-tool to audit, review, and format PL/SQL code, track and fix errors and generate interactive visuals.


Overview
Features
What's new
Documentation
Try & Buy
Clean and Clear.
ClearSQL is a powerfully-simple PL/SQL code analyzer to edit, format, validate and optimize your most complex scripts faster and easier. For whatever you're working on − deliver a consistent professional quality and structure.
The clarity's impact.
SIMPLIFY ON THE FLY
ClearSQL provides a comprehensive set of formatting and analysis rules off the shelf, improving your code's readability and maintainability.
FIND COMMON GROUNDS
Thanks to coding standards enforcement the scripts from external contractors or remote teams look and run natively, compliant with your company's rules and naming conventions.
TURN JUNIORS INTO JEDIS
ClearSQL provides highly detailed code quality reports with a comprehensive set of metrics to track and address issues. Achieving exceptional clarity and maintainability of the code has never been easier.
ENGAGE BUSINESS
Build an efficient communication with process stakeholders and analysts using interactive flowcharts and diagrams. For tech minds there are extra visual deliverables to build insights, like data flow diagrams and CRUD-matrices.
NAVIGATE THE LEGACY
With Oracle Database versions 9i to 12c, and Oracle Forms versions 6 to 11g supported, ClearSQL provides a unique opportunity to analyze, format, fix, document and visualise legacy code. Oil the gears of those "don't-touch-this" scripts, they can run much longer!
GET OUT OF A ROUTINE
You can set up your ClearSQL to run code analysis automatically and generate regular reports with issues requiring extra attention. It's so easy to build a fast and consistent submission routine for validated high-quality code now!
Opportunities for every role.
ClearSQL is an ultimate quality improvement tool for your code. Deliver faster and error-free.
Developers
Take control of the product development and validate PL/SQL code against company's specifications and rules. Easily identify areas for refactoring and structure the legacy code.
Deliver consistent, robust and error-free code.
Team-leads
Use ClearSQL to explore the logic and structure of existing software, speed-up onboarding for junior developers, ensure consistent corporate coding rules across the whole team. Use visual deliverables to bridge the gap between the dev team and process stakeholders.
Quality Assurance
Enforce quality control procedures and detect potential issues early in the development cycle. Run automated code audits and ensure rapid improvements with detailed code metrics tracking. Define rules to enable your teams deliver consistent code with minimal effort.
Let your inspiration flow.
Discover more amazing tools for Oracle professionals from Conquest.
A revolutionary platform to generate comprehensive DB documentation and run security audit.
A Swiss-army-knife of a PL/SQL developer. The smartest Oracle IDE out there.

ClearSQL 7.1.2

FEATURE TOUR

YOUR CODE RULES.
Establish corporate rules and apply them throughout your PL/SQL projects. Leave no stone unturned by checking code compliance with programming standards and industry best practices. Create unique rules and modify them as the system evolves. We've included over 10 most critical ones to get you started.
analyse and prevent.
A thorough code analysis detects potential errors and inconsistencies. It also reveals refactorable places and deep structural issues. The built-in Code Editor enables instant fix for detected issues and commits the changed script. You can also locate and identify bugs in the code by adding monitoring and tracing statements braced with a pair of conditional compilation directives.
THE EYE-CATCHING LOGIC.
Build solid understanding of processes and workflows with flowcharts, CRUD-matrices and diagrams. Visualise the workflow of a package or a stand-alone subroutine and display the conditional branches, loops, and jumps to reveal the structure.
STYLE BEYOND MEASURE.
Deliver simpler, crisper and more reliable code across the whole team, no matter the experience. With the highly detailed code quality reports and a comprehensive set of metrics, you can now track the quality variation trends and impact the coding style individually or across the team.
Deliver on schedule. Always.
Save time and effort with automated code analysis at every stage of the development cycle. A scheduler generates regular reports with errors, alerts, warnings, and other issues requiring extra attention. Fully automated QA is the new normal.
Feel the difference.
View differences between two revisions of the same script or the two separate scripts, and track changes in their content and structure. Displayed side by side, differences are highlighted and are so easy to review.
WORTH A THOUSAND WORDS.
Welcome pseudocode, inline comments that explain technical procedures! They bridge the gap between developers and business stakeholders. ClearSQL creates diagrams based on pseudocode, making complex scripts self-explanatory and visually strutured.
EXPORT & SHARE.
Export analysis results into numerous popular formats to share with your team and management. The report covers it all from general database info down to the script level.
ClearSQL 7.1.2
Learn about the latest updates for ClearSQL.
Custom rules editor
Easily create your own code review rules with XPath syntax in a Code Insight-powered editor.
Over 180 built-in rules for PL/SQL code analysis
Expert-crafted set of rules based on industry's best practice. The richest rules selection out there.
Support for extra-large scripts
Now available in 64-bit, ClearSQL 7 can swiftly process even your biggest and most complex scripts.
And more

  • Added ability to define severity levels for rules: Critical, Major, Minor, and Trivial.
  • ClearSQL is now available in 32- and 64-bit.
  • Telegram-based inline team-chat.
  • Revamped UI and visualization engine.

Even more details on the release are available in ClearSQL 7.1.2.181 release notes.

Published date: August 14, 2018
    Documentation
    See the manuals, instructions and whitepapers.
    1
    SYSTEM REQUIREMENTS: WORKSTATION
    200 MB free space
    Microsoft Windows 7 and above
    IE 9.0+, Firefox, Chrome
    administrator privileges
    Microsoft .Net Framework 4.0+, Visual C++ 2008 and 2015 Redistributable Packages (will be installed if missing)
    2
    SYSTEM REQUIREMENTS: ORACLE ENVIRONMENT
    32- or 64-bit Oracle Client 9+
    Oracle Database 9i-12c
    Buy ClearSQL
    Choose the type of license, which better matches your profile and start delivering cleaner and more performant code.
    1 user only
    any number of users
    any number of users
    1 DB instance
    unlimited DB instances
    unlimited DB instances
    pay online
    pay by invoice
    pay by invoice
    limited support
    priority support
    limited support
    ClearSQL Personal Terms and Conditions
    LICENSING
    Limited to your personal use, a ClearSQL Personal license can not be used in corporate environments, therefore only one concurrent user and one database connection is allowed.

    SUPPORT
    One year maintenance and support is included in the price. This entitles you to getting software upgrades (any minor and major versions), updates and bugfixes with no extra charge throughout 360 days since the purchase date. Maintenance and support is auto-prolongated by default, so you will get a reminder together with calculations by the end of your coverage period.

    Limited support means that Conquest Software Solutions LLC will undertake commercially reasonable efforts to resolve the issues reported by the End-User, however there is no obligation or guidance on the priority and time of issue resolution.

    TAXES
    Price indication does not include local taxes. The price including tax is indicated at the checkout stage.
    Quote request: ClearSQL
    Please fill out the form below and one of our local partners will provide you with the quote and a corporate discount. If there's no local partner in your region, you'll be contacted by Conquest sales representative directly.
    Planned number of licenses*
    +
    Educational license request: ClearSQL
    Please fill out the form below and you'll be contacted by Conquest sales representative directly. We grant officially registered educational institutions highest available upfront discount, so we'll need your proof of registration in the process.