ClearSQL is an automated code review and quality control tool for Oracle PL/SQL
  • Detect code errors, code review rule violations, and other PL/SQL code anomalies
  • Define corporate coding conventions and control their compliance
  • Perform automated, unattended code reviews
  • Avoid time-consuming peer-to-peer code reviews
  • Automate PL/SQL code analysis via scheduled jobs
  • Document PL/SQL as "clickable" HTML reports
Learn More
Analyze, edit, fix and format your oracle PL/SQL code
A powerful Oracle PL/SQL code analyzer and illustrator analyzing thousands of PL/SQL scripts and Oracle Forms at a click. Code visualization and change tracking allow rapid understanding of the code.
Make automated rule checking part of your everyday software build process

Code review rules disclose the poor use of GOTO, parameter declaration problems, unreferenced parameters, missing or misplaced RETURN, naming rule violations, unlabeled END, and other coding deficiencies.

There are over 170 predefined code review rules in ClearSQL, and you can create even more with the Rule Editor. Using XPath expressions, develop a series of unique rules to meet your corporate standards. Assign a severity level, category, and code element to each rule and include them in code analysis. Print out the rules with all their configurations and share within the team.

Learn More
Review rules are a set of tried and tested coding practices.
Check the results for coding violations. Open the source code containing violations and fix the problem. Easy. The sooner the fix, the lower the cost and effort.
Code Metrics provide insight into the complexity and maintainability of code

Halstead Volume and Cyclomatic Complexity are two popular metrics to measure code complexity.

Halstead Volume and Cyclomatic Complexity metrics are generally used together. Halstead measures the complexity of the data flow, while Cyclomatic quantifies the complexity within the code or logic.

Learn More
Reduce complexity and improve maintainability of PL/SQL code
Code complexity directly impacts software maintainability aspects such as testability, understandability, modifiability, and reusability of code.
Master Legacy PL/SQL using diagrams

Flowcharts, Call Tree diagrams, and CRUD matrices, all "clickable", are created to visualize PL/SQL code.

  • Call Tree diagrams – data flow of new or Legacy PL/SQL code
  • Flowcharts – data logic and code execution paths
  • CRUD matrices – consistency of functional requirements, identification of performance problems
Learn More
Visualized code is understood more quickly. Even Legacy PL/SQL!
Old PL/SQL code, badly documented or not documented at all, aka Legacy PL/SQL code, is hard to understand, expensive to maintain, and difficult to develop further.
Import, analyze, illustrate, and document PL/SQL of Oracle Forms & Libraries

ClearSQL provides support for PL/SQL code of Oracle Forms versions 6 – 11g. Import Oracle Forms and PL/SQL libraries into ClearSQL. Analyze, format, fix, document, and illustrate Legacy PL/SQL.

Discover the content of Forms & Libraries such as blocks, program units, and triggers. ClearSQL provides the "look and feel" of a Form’s canvas and displays the properties of its elements.

Learn More
Protect your investment in Oracle Forms applications
Using Oracle Forms applications? Clean up code, fix errors, reduce complexity, and continue. Improved maintainability saves cost and extends the useful life.
One common language fosters understanding and collaboration

The diversity of code created in distributed development environments makes the collaboration across teams complex, error-prone, and expensive. Adhering to one common standard of code development and naming conventions improves every aspect of code development and maintenance.

Learn More
Prevent Babylonian confusion by enterprise wide coding standards
Introducing and enforcing company wide coding standards is the single most effective response to the pervasive issues of code maintenance.
A new standard for software generated database documentation of Oracle databases
  • Documents 59 Oracle database object types (up to 12c)
  • Illustrates the DB via Flowcharts, Call Tree diagrams, ER and R&D diagrams, CRUD matrices of PL/SQL
  • Checks naming conventions of 59 database object types
  • Performs a comprehensive Security Audit of the Oracle DB
Learn More
ClearDB Documenter is a unique tool for Oracle databases
The Documenter generates complete, detailed, and "clickable" documentation (=Docu) of the Oracles DB, its object types, their status and dependencies, the structure and source code modules. Immediate ROI.
Capture the entire Oracle database in an interactive and easy-to-use map
  • Reference & Dependency diagrams – a graphical representation of database objects and their reference and dependency on each other
  • Entity Relationship diagrams on all levels; DB -> Schema -> Object type
  • Flowchart and Call Tree diagrams and CRUD matrices of PL/SQL
Learn More
Navigate in the Oracle DB as easily as with your navi in an unknown city
GPS-map the Oracle Database and find your way in the database labyrinth as easily as with your car navi. Visualize relationships, dependencies, logic, and dataflow. Drill down to details at a single click.
Have 'hidden scouts' monitor and report the inner life and security status of the Oracle DB

Generate a comprehensive database observation report including

  • database errors, alerts and warnings, other database anomalies
  • PL/SQL code audit and code metrics reports for stored objects, code errors, code review rule violations, other code anomalies
  • naming rule violations of DB object types
Learn More
Errors, alerts and warnings, other database anomalies
A Docu (=database documentation) also includes a complex Database Observation report with parser and database errors, alerts and warnings, as well as other database anomalies.
Be the person who can respond with confidence …

'…our Oracle databases are more secure than a year ago'

'…we monitor, document, and understand the DB security status'

'…we performed 12 security audits followed by required actions'

'…the overall Oracle database security score improved by X %'

Learn More
How secure is your Oracle database?
… a difficult but important question.
Data is a valuable asset. This makes data security a key business responsibility. If confidential data falls into wrong hands the consequences can be devastating.
Compare two snapshots of your DB. Identify differences easily and quickly
  • Objects in Source 1 missing in Source 2
  • Objects in Source 2 missing in Source 1
  • Objects in Source 1 and Source 2 with diffs
  • Objects in Source 1 and Source 2 no diffs
Learn More
A Docu is a momentary snapshot of the continuously changing DB
The Docu Comparison Report summarizes comparison information of two previously generated Docus or a Docu and the DB in one report highlighting the differences between Source 1 and Source 2.
docuVIEWER is a FREE viewer for the Documents generated by ClearDB Documenter

A Docu is generated as HTML container (interactive) and can be viewed using a standard browser or free docuVIEWER (enhanced functionality).

For security reasons a protected Docu can only be viewed in docuVIEWER. The "Instant Diagram" option in a Docu supports diagram generation on demand, but in docuVIEWER only.

Learn More
Choose between embedded, free standalone client or web application
A Docu (=documentation) generated by ClearDB Documenter contains highly sensitive information about an Oracle database and its security status. Information only authorized individuals should have access to!
5 Key Steps to Ensuring Database Security
  • Isolate sensitive databases
  • Eliminate vulnerabilities
  • Enforce least privileges
  • Monitor for deviations
  • Respond to suspicious behavior
By Fran Howarth
Learn More
Data protection and security is today the number one concern in business
DB security refers to collective measures used to protect and secure a database from illegitimate use and malicious threats and attacks. Many businesses fall victim to database intrusions because of common flaws.
Data Breach Statistics
  • records breached in the year 2016: 1,378,509,261
  • number of breach incidents: 1,792
  • percentage of breaches where number of compromised records was unknown: 52.2%
  • percentage of data breaches where encryption was used: 4.2%
Learn More
Database security should be a driving force, not an afterthought!
In 93% of cases, it took attackers minutes or less to compromise systems. Organizations, meanwhile, took weeks or more to discover that a breach had even occurred.
The Security Role of the CEO
  • 1. Change your thinking – Security is no longer the domain of the IT geeks down in the data center. CEOs and their board will be held accountable when they breached, so he has to get involved in the decision making now.
  • 2. Have a plan – Businesses aren’t made secure by accident. Appoint business executives to work with technologists (yourself included) to map things out meticulously.
  • 3. Defense in depth – Your plan needs to include multiple layers of technological defense that make sure attacks don’t fall through the cracks.
Learn More
Who is in charge at the end of a day when it comes to IT security?
"What every CEO should know about IT security" by Pat Clawson. A candid CEO-to-CEO explanation of IT risk, what you stand to lose and how to use your leadership role to build a culture of security within the organization.
Would you pay not to be ashamed?

According to a research from Bitdefender, two-thirds of 250 IT decision makers at enterprise firms say their companies would pay $124,000 to avoid public shaming after a data breach, and 14 percent would even go so far as to pay $500,000.

The willingness to pay a vast sum of money highlights just how much devastation a successful cyberattack can cause.

Read this article
Most US firms would pay to avoid data breach shame going public
The majority of US businesses admit they would pay hundreds of thousands of dollars rather than deal with the aftermath of a data breach (hack) going public.
By Charlie Osborne for Zero Day
White Paper: Top Ten DB Security Threats The Most Significant Risks of 2015 and How to Mitigate Them.

Why are databases so vulnerable to breaches?

One reason is that organizations are not protecting these crucial assets well enough. According to IDC, less than 5% of the $27 billion spent on security products directly addressed data center security.

By James Fisher, Cyber Security Consultant, UK, 2015
Open page
Slideshow: The 10 Most Common Database Vulnerabilities
It's sad but true: Some employees are going to leak or even steal sensitive data. But what are the best ways to mitigate that risk?
We Must Secure Data Not Software
Start Security in the Right Place

Security Design For Your Database Applications
Least privilege, data and ownership

Building Practical Audit Trails
Design easy to implement and use audit trails
Presentations from Pete Finnigan (click above)
The Expert

Pete Finnigan is a world-renowned expert with many years of hands-on experience in auditing and securing Oracle databases for international customers. Pete provides consultancy, design, security audits and training – all in the area of Oracle Security.

Pete has taught Oracle security audit and hacking practices to many organizations ranging from commercial, military to government and private sector all over the world.

"We must secure our data not software!!"
Pete Finnigan 2016
Conquest Software Solutions cooperates with a world-leading Oracle Security expert, Pete Finnigan, to guarantee that the "Oracle Database Security Audit" feature embedded in our ClearDB Documenter provides state-of-the-art functionality, know-how and database security experience from real life.
A powerful and easy-to-use graphical user interface to Oracle DBs
  • Writes, debugs and executes stored programs, e.g. procedures
  • Manages schemas and DB objects using Schema Extractor, Schema Compiler and Schema Analyzer
  • Compares DBs, displays differences and generates scripts to synchronize
  • Analyzes and creates Flowcharts and Call Tree diagrams of PL/SQL
Learn More
Your comprehensive development solution for Oracle databases
SQLDetective is a state-of-the-art development solution accelerating the development, the maintenance, and the administration of Oracle databases. It comprises 50 Tools and 31 database object wizards.
Run your Oracle database projects more easily
  • Develop database objects using intuitive, easy-to-use Object Editors
  • Write, debug, and execute stored programs, triggers, and other objects using the Stored Program Editor
  • Execute SQL, PL/SQL blocks, and SQL*Plus commands across multiple concurrent database sessions with the multi-threaded SQL Editors
Learn More
All user relevant features professional PL/SQL developer requires
Develop database objects, write and debug stored programs, execute, analyze, and format SQL and PL/SQL statements at a fraction of the cost of highly priced competitive products.
Write and test your code more efficiently
  • SQL Editor executes SQL and PL/SQL statements supporting bind and substitute variables
  • Debug stored programs step by step across concurrent DB sessions
  • Customizable Code Assistant, Integrated Code Insight and Code Explorer
  • View the execution plan of SQL statements hierarchically
Learn More
Developers’ choice for writing, debugging, and executing DB objects
A range of useful features to tune SQL scripts, test PL/SQL statements, write and execute stored programs, debug stored objects step-by-step. Supports Oracle 9 -> 12c.
Manage your DB with ease
  • Manage schemas and DB objects using Schema Extractor, Schema Compiler, and Schema Analyzer
  • Compare DBs, Schemas and Objects, get the differences displayed, and receive scripts generated to synchronize
  • Use a complete toolbox for handling data: Dataset Editors, Dataset Builder, Data Dependency Analyzer & Graphical Query Builder
Learn More
Navigate through DB structures using the Object Navigator
Administer/monitor sessions, tablespaces, data files, rollback segments, users & roles. Access grants for objects using Storage Manager, Session Navigator, DB Monitor, Top Session Locator, and DB Examiner.
Best practice and coding standard compliance of PL/SQL code
  • Detect code errors, code review rule violations, and other PL/SQL code anomalies
  • Avoid time-consuming peer-to-peer code reviews
  • Work smarter with code that is badly or not documented at all
  • ClearSQL's engine is embedded and allows SQLDetective to analyze (code audit) individual PL/SQL code files
Learn More
Analyze, edit, fix, and format Oracle PL/SQL code
The syntax highlighting and code folding SQL Editor supports multiple open code pages and step-by-step analysis to ensure that the PL/SQL code meets best practice and coding standards. Makes the code as clean and efficient as possible.
Diagrams or Code Metrics provide insight into the complexity and maintainability of PL/SQL code

Flowcharts, Call Tree diagrams, and CRUD matrices, all "clickable", are created to visualize PL/SQL code.

Halstead Volume and Cyclomatic Complexity are popular metrics to measure code complexity. Halstead measures the complexity of the data flow, while Cyclomatic quantifies the complexity within the code or logic.

Learn More
Visualized code is understood quickly. Even Legacy PL/SQL!
Old PL/SQL code, badly documented or not documented at all, aka Legacy PL/SQL code, is hard to understand, expensive to maintain, and difficult to develop further.
Why Choose Conquest?
5 Reasons Why
  1. You use Oracle Databases – probably for a longer time  Database programs represent a huge value of experience, effort, and time spent over many years. Conquest tools return the ability to keep the programs operational, serviceable, and enable further development. The useful life of the investment can be significantly extended.   more
  2. You own generations of badly or undocumented Legacy PL/SQL code  Maintaining unfamiliar, badly documented or undocumented code or analyzing scripts somebody else wrote is a difficult and time-consuming task. Conquest tools provide transparency and put legacy code back into an operable mode.   more
  3. You want to reduce your increasing maintenance cost of your PL/SQL programs The cost of code maintenance has grown to become the largest budget item in most software development organizations. Conquest addresses important root causes of the problem providing insight, transparency, and control to contain and reduce the issue.   more
  4. You want to document and illustrate your Oracle Databases on a regular basis Generate a comprehensive, detailed, interactive database documentation visualizing relationships, dependencies, data flows, highlighting database observations e.g. anomalies, invalid objects, and errors and documents 59 database object types. Down to the individual line of code.   more
  5. You want to increase the security of your Oracle Databases The comprehensive, automated Database Security Audit checks the Oracle database for more than 630 potential security issues. A detailed report categorizes and explains the violated checks. A unique tool to obtain an immediate, unadulterated, objective view of the database security status.   more
Conquest Tools – leading technology to Analyze, Fix, Document and Illustrate Oracle Databases
Back To Top