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!

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.

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.

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.

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.

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.

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.

The SQL formatter provides a quick and easy way of formatting SQL statements. The fomatter has different options to allow users the ability to customize the formatter to his preference.