About SQLDetective

Oracle development and database admin.

SQLDetective is a powerful, easy-to-use graphic user interface for Oracle databases. It can be used to develop database objects; write and debug stored programs, object types and triggers; execute, analyze and format SQL and PL/SQL statements; administer and monitor databases; compare databases/schemas/objects in the same or different databases, as well as browse and modify data and analyze dependencies between objects.

  • 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. Analyze 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 - 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.