A modern PL/SQL IDE. Exadata and 19c-ready. Just performant.
GET A QUOTE
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.
Please fill out the form. The download will start automatically after submitting the contact information.
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 19c with their properties, privileges, DDL, dependencies, source code and more.
Wizards and inline assistants take out the routine and give you more time to create and design.
Enjoy the code review and improvement tools, interactive visuals, integrated support for Oracle EXADATA and more.
Rethink how the teamwork looks like with a chat platform integrated into the IDE. It's fast and secure with Telegram-powered chat.
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.
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.
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.
Produce performant and maintainable PL/SQL code taking full benefit of Oracle database development 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.
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.
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.
Request product demo: SQLDetective
Add your details so we can get in touch.
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 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.
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 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 5.1 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.
Learn about the latest updates for SQLDetective.
Technical debt metrics
Calculate the price of fixing structural and logical imperfections detected by the code analyzer.
DB connections export
Export existing database connections to an XML file in a click and keep them for further reuse.
Oracle Client and Microsoft Package
Automatically check environment for the mandatory configurations and instantly connect to an Oracle DB.
Extract DDL for multiple objects directly into the code editor
Exclude system database objects from Call Trees
Easily switch between Oracle Homes in the redesigned DB Connection window
Instantly connect to a database from the startup window