Insight Developer
|
Insight Developer is an Integrated Development Environment for Oracle Database. Whether you are a database or application developer, DBA or Business analyst, Insight Developer offers all essential interface to make you more productive than ever before!
Features
1. PL/SQL debugger
2. Code completion
3. Plan Analyzer
4. Session Manager
5. PL/SQL Profiler
6. Database Explorer
7. Easy-to-use wizards performing database operations
8. Blob Editor with text and image
Detail Features:
1. Connections
Insight Developer connect to the following database versions
* Oracle9i Database
* Oracle Database 10g
* Oracle Database 11g
2. Oracle SQL or PL/SQL Editor
The Oracle SQL or PL/SQL Editor is used for most SQL and PL/SQL statement creation, with features such as a tabbed file interface, syntax highlighting, SQL and PL/SQL formatting, auto-completion hints and shortcuts, and much more.
3. Database Explorer
The Database Browser is used to quickly navigate the entire database for detailed information on various database object using a simple schema-to-object tree view. Various functions may be invoked from the Database Browser, including adding referential integrity, adding indexes, analyzing objects, generating DDL scripts, dropping objects, and viewing the Oracle 10g Recycle Bin contents.
4. Execute Store Program
Execute Consolte allow execute stored programs, including procedures, packages, package bodies, and functions with options for selecting the entry point, previewing the PL/SQL code block, setting IN parameters, displaying OUT parameters, and viewing results. Store Program can executed from Database Explorer or PL/SQL Editor
5. Explain Plan
The Explain Plan interface, a statement analysis tool, is used to describe and optimize the access paths of your SQL code using both the standard tree and a step-by-step description of each execution.
6. Integrated PL/SQL Debugger
The Integrated PL/SQL Debugger allows a user to diagnose complications within anonymous PL/SQL blocks and underlying methods (packages, procedures, etc.). The debugger comes equipped with the ability to set and control the attributes of breakpoints, exception handling, variable value hints, the call stack, a variables list, and evaluating or modifying variable values.
7. PL/SQL Performance Tuning
Profiler interface grants the ability to execute and cache statistical information on PL/SQL blocks and methods (packages, procedures, etc.). The Profiler Analysis displays this statistical information allowing a user to compare executions or view the execution statistics line by line to determine performance problems.
8. Session Manager
Provides manageability of database sessions, including user and system locks. Allowing the user to kill/disconnect sessions, start traces and monitor open cursors and user queries with execution plans.
9. Difference Viewer
The Difference Viewer displays the compared objects in a split window. Differences between the objects are highlighted. It allow compare of objects with PL/SQL file.
10. SQL or PL/SQL Formatter (Beautifier)
The SQL or PL/SQL formatter provides a quick and easy way of formatting SQL or PL/SQL statements. The fomatter has different options to allow users the ability to customize the formatter to his preference. (Only window)
The license of this software is Free Trial Software, the price is $49.90, you can free download and get a free trial.