Insight Developer for Windows Publisher's description
from T&C Solution
Insight Developer is an lightweight
Insight Developer is an lightweight, user friendly and cost-effective solution for Oracle database development.
Insight Developer connect to the following database versions:
OracleOracle Database 10g
OracleOracle Database 11g
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.
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 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
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.
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.
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.
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 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
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)
What's New in This Release:В· If not connect to database, open Debug Menu cause application termination
System Requirements:В· 30 MB RAM
В· Pentium-133 MHz
В· 15 MB Hard Disk
В· Oracle database
Program Release Status: New Release
Program Install Support: Install and Uninstall