Experience the art of coding.
A modern PL/SQL IDE for professional code management, debugging and performance monitoring to develop performant 12c- and Exadata-ready applications.

Overview
Features
What's new
Documentation
Try & Buy
Indulge your productivity.
SQLDetective offers an extensive toolset of over 50 functional modules to help you design, code and maintain your DB faster and smarter.
Crush the code.
SQLDetective supports 59 object types in Oracle Database 12c with their properties, privileges, DDL, dependencies, source code and more.
Intelligent
Wizards and inline assistants take out the routine and give you more time to create and design.
Feature-reach
Enjoy the code review and improvement tools, interactive visuals, integrated support for Oracle EXADATA and more.
Team-friendly
Rethink how the teamwork looks like with a chat platform integrated into the IDE. It's fast and secure with Telegram-powered chat.
Built around your every need.
DEVELOP SMARTER
Create and change attributes for tables, views, triggers, indices, clusters, collections, jobs and other objects with feature-rich wizards.
Avoid common mistakes and code consistently using inline Code Analyzer.
MANAGE EVERYTHING
Pin down those pesky bottlenecks, monitor and adjust database and session performance deep down to low-level parameters.
TEST, TUNE & DEBUG
Use bind and substitution variables in statements and step through the code with a multifunctional debugger. View execution plans and fine-tune conveniently with Explain Plan feature.
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.
MASTER THE DATA
Any query is built with ease with a visual Dataset Builder. Popular formats are natively supported, so you can move around scalar and complex data types.
MADE FOR PROs
Tasks are performed faster with the needed tools always at hand. The essential and pro-level functions are logically organized in an adjustable UI. You can even work with several databases at once and switch on the fly.
A great toolset for every role.
SQLDetective is a robust PL/SQL IDE with an exceptional coverage for development-related functional areas.
Developers
Produce performant and maintainable PL/SQL code taking full benefit of 12c and Exadata functionality. Develop faster with wizards and inline assistants. Improve execution plans and resolve bottlenecks with detailed debugger and tracer. Tune the IDE to familiar shortcuts and behaviour in a click.
Architects
Write strong, structured code ensuring corporate standards and integration requirements are met. Troubleshoot DB architecture problems, plan migrations and scale-ups with itemised reports and interactive diagrams. Schedule times for upgrades and repairs with detailed engine statistics.
Professional DBAs
Monitor and manage sessions, tablespaces, data files, rollback segments, users & roles with full support for Oracle RAC. Control object grants, locate top sessions and troubleshoot query performance. Implement your DevOps strategy with ease with a unified tool.
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.
An ultimate validator and quality improvement tool for your code.

SQLDetective 4.7

FEATURE TOUR

Create with ease.
Configure settings for each DB object with its own wizard. Grouped by 59 object types, wizards provide full access to complete object-related configurations and object attributes.
Understand dependencies.
Understand unfamilar PL/SQL and figure out data dependencies with a help of a Data Dependency Analyzer. It represents referring data based on integrity constraints, like primary key, foregin key, and unique key.
User-friendly environment.
SQLDetective features a configurable environment that allows full customization. Use the predefined interface and shortcut settings from one of the classic tools or create those of your own.
Code quality delivered.
Make your code easy to maintain and detect potential errors and inconsistencies early in the development cycle with the extended set of Code Review Rules.

Enjoy a stunning visual experience analyzing objects, workflows and scripts with interactive flowcharts and call tree diagrams, metrics reports and CRUD matrices.
Refined version control.
SQLDetective can track changes for a database, a schema or an object giving you an unprecedented degree of refined control over versioning. Individual changes are highlighted and color-coded making it easy to read differences. To track progress, you can receive automated comparison reports, too.
Migrate smoothly.
Migrate databases using DDL. Extract DDL at the object and schema levels using either Oracle's DBMS_METADATA or SQLDetective's native engine. This ensures that no object of property is left behind during the migration or bulk replication.
Develop for performance.
With the new SQLDetective 4.7 you can now develop specifically for Oracle Exadata — make most of Columnar Compression, Flash Cache and refined access to storage cell specific functionality.
Take your data anywhere.
Export and import scalar and complex data types into many popular enterprise and desktop formats. Browse, search and modify data across massive arrays in a snap.
SQLDetective 4.7.2
Learn about the latest updates for SQLDetective.
Full support for Oracle Database 12c
Support for a complete set of 59 database object types in 12c.
DBMS_METADATA or a built-in engine
Switch between Oracle's native or SQLDetective's engine to punch individual objects or an entire Oracle schema.
Rules editor
Create your own code review rules with XPath syntax.
And more

  • "SQL Execution Wrapper" in the "SQL Editor" allows enclosing any script execution by "start" and "finish" commands.
  • A powerful data protection feature provides granular control over the execution of potentially unsafe statements, copy and import operations.
  • Telegram-based chat.
  • Support for Exadata storage cells specific functions and attributes.

Even more details on the release are available in SQLDetective 4.7.2 (build 228) release notes.

Published date: Apr 12, 2018
    Earlier releases ↓
    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-bit Oracle Client 9+
    Oracle Database 9i-12c
    Buy SQLDetective
    Choose the type of license, which better matches your profile and start writing faster, simpler and more reliable 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
    SQLDetective Personal Terms and Conditions
    LICENSING
    Limited to your personal use, a SQLDetective Personal license can not be used in corporate environments, therefore only one concurrent user 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: SQLDetective
    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: SQLDetective
    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.