|
|
Isidian® SQL Insight vastly increases the productivity of database users by decreasing development time and eliminating the majority of errors, thus allowing quicker turn around on product development.
The performance tuning features provided ensure that, not only will the development time be shorter, but the finalized product created using SQL Insight will run faster and with less overhead, adding to the satisfaction of your end users.
By adding Isidian® SQL Insight to your development tools repository, application and database developers possess the ability to create superiority in their products, on time.
|
The powerful coding editors within Isidian® SQL Insight, used for most SQL and PL/SQL statement development, contain a wealth of features and benefits to increase the accuracy and productivity of the user. The tabbed editors system allow for the creation or modification of multiple files simultaneously, across multiple database connections, providing one simple, low footprint tool to handle your entire project.
 Statement editors support various file types, SQL, PL/SQL, Java, HTML, XML, C++, and Perl. Additional files types may be downloaded or customized by the user.
Syntax Highlighting reduces the probability of errors by providing offline syntax checking.
Statement formatters provide the ability to format created statements to adhere to company standards.
Completion proposals speed development by use of shortcuts or displayed hints to automatically generate commonly used and configurable code segments.
Object auto-completion provides the user to generate their code quickly without having to reference schema diagrams or various browsers.
From one editor, a user may create and execute a query, PL/SQL block, DDL statements, and scripts without having to switch between different interfaces.
|
Creating ad hoc reports, professional reports, analyzing and administering data, and producing query results has never been easier. The grids utilized within Isidian® SQL Insight provide an unsurpassed graphical interface to data that allow users to search, filter, or create professional looking reports from a simple query result.
Searching for data within a grid can be done by simply typing in what you are looking for within a column.
Columns may be sorted, one or more at a time, ascending or descending.
Filters can be applied to a data set with only a mouse-click. Complex filters may be generated this way or by use of a wizard.
Column may be dragged and grouped to infinite levels, creating a hierarchical display of the data set.
Summary Footers provide column calculation displays, such as the average or summation of the column's data.
Raw data may be exported from the grids, producing text files, CSV files, insert scripts, or any form of delimited file desired.
Once you've applied your desired formatting to a data set, filtering, grouping, summaries, etc., the resulting data set may be saved to an Excel, XML, HTML, or text file, preserving the formatting you've specified.
Row View may be invoked to view data, row-by-row, in a form design layout rather than a grid.
The grids support integrated LOBs, displaying images, text objects, and more directly in the grid.
|
|
 |
When creating PL/SQL blocks or object source, your source is likely to contain errors or faulty logic that alters the execution from its intended path. Debugging is the process of seeing the execution path and locating errors within your source.
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 very details aspects of breakpoints,
exception handling, variable value hints, the call stack, an automatically generated variables list, and evaluating or modifying variable values.
Available within the Professional Edition. |
The SQL Builder implements an intuitive Designer to generate simple to complex queries in a simple graphical interface. The SQL Builder interface even allows for sub-selects, custom variables, and printing or saving the layout for schema diagram generation. The SQL Builder works in combination with the Database Browser (and / or My Schema) to generate select statements on select statements against select tables and views from the Database Browser.
To begin using the SQL Builder, simply drag-and-drop a table or view from the Database Browser into the SQL Builder area. |
 |
 |
Describing an object is used to gather specific information on an object within your database. This information could include the columns of a table, the source code of a package, or the general information of a sequence. SQL Insight's Describe interface provides a tabular display containing all possible information for the object and provides several function points for the object.
You may also describe a user/schema, which instead of the standard describe window, you will be given a database browser containing only the desired user. |
Isidian® SQL Insight provides a Project Manager to help manage files, scripts, paths, and database connections in one simple interface. Project files may be opened and saved as normal files, allowing you to have multiple project configurations.
Each project allows for easy navigation and control of the Isidian® Desktop interface and commonly used or project related files. |
 |
The tools described above are only part of vast feature set Isidian® SQL Insight provides. For further information, please review the Product Data Sheet, or download the trial edition today.
|