SQLDetective - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

SQLDetective by Conquest Software Solutions

URLs: sqldetective, conquest-software, conquest software, conquestsoftware

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.

SQLDetective Core Program:

Build your database projects more easily

SQLDetective is a powerful and easy-to-use graphical user interface for Oracle databases. It provides an integrated environment for developing database objects, writing and debugging stored programs, executing and testing SQL and PL/SQL commands, as well as searching and modifying data and analyzing the dependencies between the objects. The visual object editors allow users to quickly create and modify database objects such as: table, view, trigger, index, job, cluster, synonym, operator, etc depending on Oracle database version. Syntax highlighting and code folding, Code Editors, Code Helper, Code Insight and Integrated Oracle Documentation Browser allow the user to write procedures, functions, packages, object types, triggers and Java in a high quality and error free way. Object Navigator facilitates easy navigation of database structures by displaying database schema objects and their relationships in an intuitive hierarchical interface.

Write and test your code more quickly

SQLDetective includes a range of handy utilities to tune SQL scripts, test PL/SQL statements, write and execute stored programs, debug stored objects step-by-step. SQL Editor executes SQL and PL/SQL statements supporting bind and substitute variables. The advanced Stored Program Editor offers an easy-to-use interface for writing and executing stored programs. The fully integrated PL/SQL Debugger offers all features that a user could wish for: step over, step into, step out, run until exception, break execution, set conditional breakpoints, view and modify scalar and complex variables and more, to debug stored procedures, functions, packages, type bodies and triggers on a database server. Format and improve the quality of PL/SQL code using ClearSQL - a code review and quality control tool for Oracle PL/SQL development.

Administer your database more simply

SQLDetective empowers DBAs with powerful and easy to use administrative and monitoring tools and utilities such as: Database Examiner which provides easy access to database information such as: database system; instance options; initialization and NLS parameters; system events and statistics; SGA memory allocation; list of sessions; tablespaces, datafiles, rollback segments, etc.; Database Monitor monitors real-time database performance and displays: Logical, Physical and Disk I/O, Event Waits, Host CPU usage, Instance performance time, Sort Ratio, SGA, Hit Rates, Recursive Calls, and many others in charts grouped by categories; Top Session Locator locates the most resource consuming sessions in the database using different activity and Event Waits parameters such as: CPU, Logical I/O, Physical I/O, Parsers, Concurrency, User I/O, System I/O, etc.; Storage Manager manages tablespaces, datafiles, segments and quotes in the database instance; Session Navigator manages sessions and displays information on different sessions.

Manage your data

SQLDetective is a complete environment for handling data. Dataset Editors allow users to quickly browse, search, modify, analyze and export & import scalar, object table, collection, REF and LOB types of data. Utilize advanced Export and Import Data utilities to export and import scalar and complex types of data into a number of popular formats like SQL INSERT Script, SQL MERGE Script, Microsoft Excel, XML, PDF, HTML, Char Delimited, etc. The powerful Dataset Builder allows users to create complex datasets without having to write a query. The Data Dependency Analyzer provides a graphic environment to represent and modify the referring data based on integrity constraints. The graphical Query Builder allows users to represent the server data model and create a query of any given complexity, on its basis.

Configure your environment more conveniently

SQLDetective has been developed using plug-ins. This technology allows users to customize the product to the business processes being run by the user when developing, implementing and supporting Oracle-based applications. The program features a fast, easy-to-use environment that allows users to customize the workspace and visual tools on request. The Oracle Client Interface (OCI) allows users to utilize all database benefits and dispenses with the installation of additional drivers (e.g. ODBC or JDBC) in user's workstation.

SQLDetective is available with optional kits that extend and customize its functionality on the basis of individual user requirements:

Developer Kit:

Compare Databases, Schemas & Objects - compares and displays the differences graphically and generates a synchronization script for: two different databases; one or more schemas in the same or different databases; or one or more objects in the same or different databases with the definition of schema and non-schema types and name filters.

PL/SQL Debugger - debugs procedures, functions, packages, object types and triggers, step by step. The feature provides all the facilities required to quickly and accurately debug the program code on a database server.

Data Dependency Analyzer - analyzes and modifies the dependencies between data, based on integrity constraints. It accelerates the localization of the problem of data dependency throughout the process of supporting databases.

Repository and Version Control System - provides instant access to frequently-used database objects, user-defined Smart Datasets, SQL statements, PL/SQL and JAVA code templates and any other text information. The powerful built-in and third-party version control systems such as Microsoft Visual Source Safe, Merant PVCS and others that support Microsoft SCC API, allow for save and control of object versions.

Oracle E-Business Suite object description - quickly access the OEBS object description in the development environment. This unique feature is specifically developed for Oracle*E-Business Suite IS implementation and support staff.

DBA Kit:

Session Navigator - manages sessions in the database instance and is used to view a different session's information such as: open cursors, locks, event waits, long operations, transactions, input and output, statistics etc. It provides a wealth of settings and allows the user to kill and disconnect sessions, and to enable and disable SQL tracing for the selected session(s).

Storage Manager - manages tablespaces, datafiles, segments and quotes in the database instance. It provides an easy to use interface to create, modify, change status, coalesce and drop tablespaces; to create and change the status of datafiles; to relocate and move objects; to create, modify and delete quotes; to show different tablespace information such as: used, free and max size; free space; objects etc.

Database Monitor - monitors real-time database performance and displays information such as: Logical, Physical and Disk I/O, Event Waits, Host CPU usage, Instance performance time, Sort Ratio, SGA, Java and Shared Pool, Hit Rates, Recursive Calls, and many others in charts grouped by categories.

Top Session Locator - locates the most resource consuming sessions in the database using different activity parameters such as: CPU, Logical I/O, Physical I/O, Parsers, etc.; and Event Waits parameters such as: Concurrency, User I/O, System I/O, etc.

Database Examiner - provides easy access to database information such as: database system; instance options; initialization and NLS parameters; system events and statistics; SGA memory allocation; list of sessions; tablespaces, datafiles, rollback segments, users, profiles, roles, contexts, directories, database and schema triggers; and resource limits.

Code Analyzer Kit

The Code Analyzer Kit is a code review and quality control tool for Oracle PL/SQL development, built around a code analyzing technology and an advanced code editor. It improves the quality of PL/SQL code while increasing the productivity of the software team; instantly formats the PL/SQL code to a set of code conventions that improve the readability of the software, allowing engineers to understand the new code more quickly and thoroughly; analyses PL/SQL code for its structure and architecture and generates a series of industry standard quality control metrics that identify possible error prone procedures based on complexity, size, modularity and keeps the code reliable, testable and manageable. The Code Analyzer Kit uses ClearSQL's parser engine for PL/SQL.

Oracle development and database admin.

Pricing: SQLDetective 4.3.1 core program 1 User License, SQLDetective 4.3.1 core program 2 User License, SQLDetective 4.3.1 core program 3 User License, SQLDetective 4.3.1 core program 5 User License, SQLDetective 4.3.1 core program 8 User License, SQLDetective 4.3.1 core program 10 User License, Developer Kit - (requires SQLDetective core program) 1 User License, Developer Kit - (requires SQLDetective core program) 2 User License, Developer Kit - (requires SQLDetective core program) 3 User License, Developer Kit - (requires SQLDetective core program) 5 User License, Developer Kit - (requires SQLDetective core program) 8 User License, Developer Kit - (requires SQLDetective core program) 10 User License, DBA Kit - (requires SQLDetective core program) 1 User License, DBA Kit - (requires SQLDetective core program) 2 User License, DBA Kit - (requires SQLDetective core program) 3 User License, DBA Kit - (requires SQLDetective core program) 5 User License, DBA Kit - (requires SQLDetective core program) 8 User License, DBA Kit - (requires SQLDetective core program) 10 User License, Code Analyzer Kit - (requires SQLDetective core program) 1 User License, Code Analyzer Kit - (requires SQLDetective core program) 2 User License, Code Analyzer Kit - (requires SQLDetective core program) 3 User License, Code Analyzer Kit - (requires SQLDetective core program) 5 User License, Code Analyzer Kit - (requires SQLDetective core program) 8 User License, Code Analyzer Kit - (requires SQLDetective core program) 10 User License, Annual Maintenance Support (AMS) for SQLDetective core program 1 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for SQLDetective core program 2 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for SQLDetective core program 3 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for SQLDetective core program 5 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for SQLDetective core program 8 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for SQLDetective core program 10 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for Developer Kit 1 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for Developer Kit 2 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for Developer Kit 3 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for Developer Kit 5 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for Developer Kit 8 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for Developer Kit 10 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for DBA Kit 1 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for DBA Kit 2 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for DBA Kit 3 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for DBA Kit 5 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for DBA Kit 8 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for DBA Kit 10 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for Code Analyzer Kit 1 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for Code Analyzer Kit 2 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for Code Analyzer Kit 3 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Support (AMS) for Code Analyzer Kit 5 User License - 1 Year Annual Maintenance Support (AMS), Annual Maintenance Supp

Evals & Downloads: Read the SQLDetective help file, Read the Conquest Software Solutions License Agreement, Download the SQLDetective 4.3.1 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows 7, Windows Server 2008, Windows Vista, Windows XP, Windows Server 2003

Architecture of Product: 32Bit

Product Type: Application

Compatible Containers: Oracle Database 9i, Oracle Database 10g, Oracle Database 11g

Keywords: SQLDetective

Conquest Software Solutions

Database DB Management

Database DB Connectivity

SQL query language

Part numbers: PC-540572-360547 540572-360547 PC-540572-360548 540572-360548 PC-540572-360549 540572-360549 PC-540572-360550 540572-360550 PC-540572-360551 540572-360551 PC-540572-360552 540572-360552 PC-540572-360553 540572-360553 PC-540572-360554 540572-360554 PC-540572-360555 540572-360555 PC-540572-360556 540572-360556 PC-540572-360557 540572-360557 PC-540572-360558 540572-360558 PC-540572-360559 540572-360559 PC-540572-360560 540572-360560 PC-540572-360561 540572-360561 PC-540572-360562 540572-360562 PC-540572-360563 540572-360563 PC-540572-360564 540572-360564 PC-540572-360617 540572-360617 PC-540572-360618 540572-360618 PC-540572-360619 540572-360619 PC-540572-360620 540572-360620 PC-540572-360621 540572-360621 PC-540572-360622 540572-360622 PC-540572-360565 540572-360565 PC-540572-360566 540572-360566 PC-540572-360567 540572-360567 PC-540572-360568 540572-360568 PC-540572-360569 540572-360569 PC-540572-360570 540572-360570 PC-540572-360571 540572-360571 PC-540572-360572 540572-360572 PC-540572-360573 540572-360573 PC-540572-360574 540572-360574 PC-540572-360575 540572-360575 PC-540572-360576 540572-360576 PC-540572-360577 540572-360577 PC-540572-360578 540572-360578 PC-540572-360579 540572-360579 PC-540572-360580 540572-360580 PC-540572-360581 540572-360581 PC-540572-360582 540572-360582 PC-540572-360623 540572-360623 PC-540572-360624 540572-360624 PC-540572-360625 540572-360625 PC-540572-360626 540572-360626 PC-540572-360627 540572-360627 PC-540572-360628 540572-360628

Mfr. Part No: 3276900 32769101 32769102 32769103 3276914