New features and improvements

• Core
• Advanced bug catching feature integrated with Online Support Desk (OSD).
• New feature "Sort Alphabetically" - sorts list of object types in Schema Compiler, Schema Extractor, Find Object and Create New Object.
• SQL Editor
• Marks the last executed statement with a specific icon; an icon’s tool-tip displays detailed information about the last executed statement.
• Displays a Data Output tab sequence number in its caption.
• Support for the SQL*Plus command: TIMING START/STOP/SHOW
• New tab “Errors” for collecting and displaying statement/script execution errors.
• Keeps user-defined column customization on statement re-execution.
• Code Folding considers an empty line dividing statements a statement delimiter if the appropriate option is enabled in Preferences (Code Editors -> Display -> Code Folding).
• Activates the SQL Output tab instead of the DBMS Output tab on statement execution error.
• Object Navigator
• Object Properties tab displays new properties such as: OBJECT_SIZE, EXTENTS, DEBUG_INFO, NATIVELY_COMPILED, LAST_COMPILED.
• Added a new menu item to the popup menu: "Show Differences from Another Object".
• Added a new menu item to the popup menu: "Compare with Another Object".
• Code Editors
• New feature “Format Code” – ClearSQL formats code without displaying any analytical information, avoids popping up the result window.
• Marks modified and saved/compiled lines on the editor’s gutter with different colors.
• SYSDATE can be used as a value for the date type bind variable.
• Data Grid
• Fixes and unfixes grid columns.
• Query by Example Editor (QBE) provides ability to write complex filter and sort conditions in the Export mode.
• Displays a record number in Singe-record view mode.
• Preferences
• Searches for settings and options.
• New setting "PL/SQL Optimization Level" (General -> Session page) - sets the session PLSQL_OPTIMIZE_LEVEL parameter.
• New option "Number all lines" (Code Editors -> Display page) - controls drawing line numbers on the editor's gutter.
• New option "Read DBMS_OUTPUT after executing a select statement" (Code Editors -> DBMS Output page) – controls reading and displaying DBMS_OUTPUT data after select statement execution.
• New option “Print dataset query and connection string in report title” (Dataset Editors page) – controls output of source query and connection string in the dataset reports.
• New option “Ignore SQL*Plus commands” (Code Editors -> SQL Editor -> SQL Output page) – controls counting SQL*Plus statements in the script execution statistic report.
• New setting “Text auto conversion” (Code Editors -> Color page) – controls text auto conversion (uppercase, lowercase, init caps) in the editors.
• New setting for thousands separator (General page).
• Stored Program Editor
• Improved performance of Code Explorer.
• Improved ability to save object modifications to database/file on object close.
• Code Insight
• Shortcut key assignment improved.
• Chooses templates in Editor when there is no oracle connection.
• Compare Databases
• Compares object privileges.
• Excludes system generated objects.
• Export Data
• Sorts a list of exporting objects by using the master-detail relationships rule.
• Describe Object
• Navigates to an object in ObjectSelector on which the synonym is based.
• Trigger Wizard
• Support for Code Folding.
• Data Dependency Analyzer
• Displays integrity constraints icons on datagrid titles.
• System Information
• Displays most important OS Environment Variables.

Bug fixes

• Object Navigator
• Public synonyms weren’t displayed in ContentSelector when the Tables -> Synonyms folder was selected in ObjectSelector.
• The DDL tab of ObjectSelector displayed an invalid DDL for an object that has been dropped in SQL Editor and hasn’t been refreshed in ObjectSelector yet.
• Did not display object properties for foreign key and check constraints.
• Did not display the trigger property: trigger body.
• SQL Editor
• Semicolon at the end of comment line was considered a statement delimiter
• "Go to next statement" falsely navigated inside of stored objects source code.
• A token starting with “&” in “string” of PL/SQL code was considered as a substitution variable.
• Export Data
• Could not export data is based on a statement containing a TAB character immediately after the FROM clause.
• Describe Object
• Raised "list out of bounds" error on object description from within SQL Editor on lost connection.
• Stored Program Editor
• Did not display execution result if a package’s subprogram was executed from within the package specification.
• Ignored the setting “Rewrite the folder on file saving”.
• Storage Manager
• TEMP tablespace having more then one datafile was displayed as duplicated.
• Built-in VCS
• Worked slowly on remote databases.

New tools and utilities:

• Database Monitor - monitors real-time database performance and displays information in charts grouped by categories; saves gathered information in the background and plays it back for a selected period; and defines alerts and notifies the user in a variety of ways.
• 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.
• Top Session Locator – locates the most resource consuming sessions in the database using different activity parameters: CPU, Logical I/O, Physical I/O, Parsers, etc.; and Event Waits parameters: Concurrency, User I/O, System I/O, etc.
• Compare Databases & Schemas & Objects – compares, displays the differences 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 object filters.
• TKPROF Shell – a utility that greatly simplifies the usage of the Oracle command line utility TKPROF by providing the user with a graphical interface to all of its parameters and options from within the application.

Other significant enhancements and improvements:

• Code Folding - selectively collapses (hides) and expands (shows) sections of SQL and Pl/SQL code to make it easier to navigate and read. It helps manage large regions of potentially complicated code within one editor, while viewing only the desired subsections of code during a particular editing session.
• Schema Compiler - added ability to auto refresh within a certain time period; recompile invalid objects; and send an email alert if invalid objects exist after auto-recompilation.
• SQL Editor - displays editor pages as tabs; renames tabs and synchronizes editor and data output tab navigation; and provides a new user interface for Editor Page List.
• Connection Window - remembers the selected Oracle Home and Auto Login settings for a History Connection item.
• Object Navigator – improved ContentSelector: Objects, Columns, Data, DDL dataset performance; automatically refreshes object information in ObjectSelector (Object Navigator Tree) when an object is changed in Object Wizard.

New tools and utilities:

• Macro Recorder - quick and easy records and plays back a set of keystrokes, mouse movements and clicks. Macro is used to automate and dramatically reduce time for resolving specific repetitive tasks .
• Assign individual DB types – a list of pre-defined and user-defined DB types . This feature helps you to organize your DB connections in groups; e.g. DEVELOPMENT, PRODUCTION, TEST and others. Assign background and foreground colors to easy identify them while working with the content of your mission critical DB's
• XML Editor – a graphical user interface for creating and modifying XML documents and XML Type columns.
• Find in Files – is a graphical interface to find and/or replace text in files. It provides abilities to load the found file in: SQL Editor, Stored Program Editor and external editor; execute the file as a script in SQL Editor and SQL*Plus, etc .
• Full-screen Mode – switches the active window to full-screen mode, increasing its workspace.
• Dataset Calculator – an imbedded calculator for displaying and calculating numeric data in datagrids.

Other significant enhancements and improvements:

• Core
  • Moves and stores, if a previous version of SQLDetective is found, the application's read/write files to the “..\Documents and Settings\<User>\Application Data\SQLdetective\...” folder. This feature avoids access problems for non-privileged MS Windows users and simplifies a Network type installation.
  • New “DB Type” property of connection allows the differentiation of different kinds of databases (development, production, etc.) by different background color.
  • Added ability to find previous occurrences of a word.
  • Improved stability of the program run under the limited MS Windows user.
• Object Navigator
  • New tab “Columns” of ContentSelector displays a list of columns with detailed information for a selected table, view or materialized view in the ObjectSelector.
  • ObjectSelector displays an object as a sub-node for which the synonym is created.
  • “Load in Stored Program Editor” popup menu of ObjectSelector loads selected triggers in a Stored Program Editor window.
  • ContentSelector displays comments for tables, views and columns.
  • ContentSelector displays “not null” check constraints.
  • Remembers the "selected" tab in ContentSelector for a particular object.
• Preferences
  • The "Rollback on disconnect" setting has been changed to "On disconnect: Commit, Rollback, Prompt for Commit/Rollback if changes detected".
  • The “Code Editors->SQL Editor” and “Code Editors->Stored Program Editor” pages have been split to several pages.
  • “Autom. display integrity constraints icon on column header for: SQL Editor, Smart Dataset, Other datasets” setting was added to the Dataset Editors page.
  • "Click on the column title sorts data on the: Server Side, Local Side" setting was added to the Dataset Editors page.
  • "Allow cursor beyond EOF" setting was added to the “Code Editors” page.
• Find Object
  • Support for regular expressions.
• Object Privileges
  • Completely new graphical user interface.
  • Support for multiple objects.
• Stored Program Editor
  • Creates, modifies and debugs database triggers.
  • Provides ability to split multiple objects in a file to different tabs. The setting can be found in the Stored Program Editor page of Preferences.
  • Added ability to combine an object type specification and body to a single file on saving. The setting can be found in the Stored Program Editor page of Preferences.
• Describe Object
  • Support for multi-selection. Extracts DDL, browses and copies name for selected objects.
  • Support for materialized views.
  • Displays constraints information for the columns that belong to them.
  • Added the “Locate in ObjectSelector” feature.
• Object Properties
  • Displays comments for tables, views and columns.
• Dataset Editor
  • “Execution Query” window displays number of fetched records while getting them from the database.
  • Improved selecting of cells and records in datagrids.
  • “Re-sort data” menu item added to the popup menu of datagrid title.
  • Changes background color of datagrid's indicator on data sort.
  • Statusbar displays the number of fetched records from the database.
  • Added ability to open a dataset in read-only mode. The setting can be found in the Dataset Editors page of Preferences.
• Export Data
  • Support for export to “MERGE” script.
  • Support for export of object type columns to “INSERT” and “MERGE” scripts.
  • Support for exporting columns of object types, nested tables and varying arrays.
• Dataset Manager
  • “Reverts Changes” menu item has been added to the popup menu.
• Code Explorer
  • Improved expanding tree nodes.
  • Added the “Expand All” and “Collapse all” features.
• Duplicate Record
  • Completely new graphical user interface
  • Displays the source and new record, allows modification of the new record before processing.
  • Added a feature to define a number of copies.
• Online Support Desk
  • Added ability to send the program settings.
  • Checks the OS user rights to update SQLDetective and its add-ons.
• PL/SQL Debugger
  • Improved display of execution information during debugging.
• Clear SQL
  • Prints the flowchart diagram.
  • Support for INTERVAL data types.
• Constraint Wizard
  • Improved GUI and became sizable.
• Connection Window
  • “Assign DB Type” and “Delete Selected Connections” features can be applied for multiple records in Last Connections.
• SQL Editor
  • Executes snippet at cursor.
  • Improved saving SQL History.

Bug fixes:

• Object Navigator
  • Did not show indexes from other schemas.
  • Incorrectly went to the brief mode in the maximized state.
• Find Object
  • Displayed the object in the result pane as many times as the searched word appeared in its source code.
  • Displayed incorrectly in the maximized state.
• Dataset Editors
  • Caused several “Access Violation” errors after opening the Embedded Editor in the Single Record View mode and then closing the window.
  • Double click on the first cell did not open an Imbedded Editor.
• View Differences
  • The horizontal scrollbar did not work correctly.
  • Double click on a word in the left pane text did not select it.
  • The fields for displaying selected objects/files for comparing were updatable.
• SQL Editor
  • Did not save the date type bind variables correctly.
  • Text selection disappeared might work incorrectly.
  • Could not execute a script file in SQL*Plus.
  • Recognized :NEW and :OLD as bind variables while executing a trigger.
• Extract DDL
  • Switched back to the restored state of maximized windows.
• Job Wizard
  • Trunc function used in Interval was extracted incorrectly.
• Stored program Editor
  • Compiling some stored programs might change the object name in the tab due to incorrect parsing of source code.
  • Did not display the error position in the stored object body when the stored object specification tab was active in the editor.
  • Did not take into account comment signs for a sub program while locating it in source code.
• Object Properties
  • Might display wrong properties while switching between different objects of different type.
• Connection Options
  • Could not close the window after making changes in options if oracle client was not installed.
• Export Data
  • Adding objects from one session and then switching to another session caused errors on extraction start.
  • Could not export a single selected cell.
• Clear SQL
  • “At least one linefeed around an IF statement'” setting did not work for the inner IF statements.
• Code Editors
  • “Back Space” did not work correctly with leading spaces.
• Evaluate Watch
  • Could not assign a NULL value for a watching variable.

Features and improvements:

• SQL Editor – The “Execute all statements from the cursor position” feature executes all statements loaded to the editor from the cursor position to the end of a script. A plan table is automatically selected, if any, on the initial openening of the Explain Plan tab. A public synonym created for a plan table can be selected for the PUBLIC schema. TIMESTAMP and INTERVAL data types are supported as bind variables.
• PL/SQL Debugger – “ Evaluate/Modify ” and “Watch” dialogs, and saving and restoring breakpoints and watches have been improved. Showing debugging-time errors has been moved from the Execution tab to the Errors and Warnings tab.
• Online Support Desk – Sends files with different formats as attachments. Saves a message as Draft. The Online Support Desk utility and its New Message window are now non-modal. Displays Release Notes for a new build after checking for updates.
• Icon Dictionary – Displays related actions/icons for the selected movie on the Action Navigator tab. Filters movies by SQLDetective version. The “Delete Selected Temporary Node” and “Delet All Temporary Nodes” menu items have been added to the Action Navigator and Movie Navigator popup menus.
• Clear SQL – Saves and prints data from the Stucture, Code Review and Metrix tabs.
• Data Grid – “Autofits to Data and Title” applies when the user double-clicks on the right vertical line of the column title, as in MS Excel.
• Code Editor – Copies text from the editor in RTF format. Copied text is pasted to the external editors like MS Word as it is without losing formatting and highlighting.
• Object Navigator – The object name in ObjectSelector's tree is displayed in red for an invalid object, and in gray for a disabled object. A popup menu has been added to the ContentSelector's grid in Single Record mode.
• Oracle Documentation Library – Managing HTML documentation folders has been improved.

Bug Fixes:

• SQL Editor
  • The first execution of a stored program that outputs HTML caused an error.
  • Line breaks in text sent by DBMS_OUTPUT.PUT_LINE were not properly recognized.
  • Total execution time did not display milliseconds.
  • Execution of a script with a comment that contained empty lines caused an error.
  • Could not execute a statement with the MERGE INTO clause.
  • An executed query that had the ‘&' character could not be located in the Editor.
• Export and Import Data
  • Added new date formats to “Import Data” wizard.
  • The process of importing Excel data stopped on an empty line occurance. The "Ignore empty lines" option has been added to the “Import Data” wizard.
  • First row was empty when data exported to MS Excel.
  • Could not export several tables at a time to the PDT and XML format.
  • Unsupported date format removed from the drop-down list for exporting to the INSERT script.
  • User defined date format and font in “Export Data” wizard ignored on export data to MS Excel.
  • The initial query was printed on all pages on exporting data to PDF format.
• PL/SQL Debugger
  • Sometimes deleted breakpoints might become active on next debugging.
  • Breakpoints set in Package/Type Body restored incorrectly on next open of a package/type.
  • Fixed problem with modifying DATE watches.
• Query Builder
  • INSERT statement was generated with ROWID psedo-column.
  • UPDATE statement could be generated with ORDER BY clause.
• Stored Program Editor
  • Cause an error in Windows 98 on open without a session.
  • File parser might fail when a non-pl/sql file is opened.
• Connection Window
  • Saving passwords was improved. The “Save passwords” option has been removed from the “Connection Settings” window.
• Object Navigator
  • Locating objects of Recycle Bin in ObjectSelector's tree did not work correctly.
• Storage Manager
  • Temporary tablespaces always showed 100% used.
• Preferences
  • The vertical scrollbar has been removed from the “Warning numbers” grid of the “Compile-time Warnings” page.
• Session Navigator
  • Clicking on the Close button in the Confirmation dialog of the “Kill Session” feature interpreted as OK instead of Cancel.
• Icon Dictionary
  • Explain Plan caused the “Access Violation” error in Education Mode on close.
• Code Editor
  • The Editor did not show a line pasted from Clipboard when it was pasted to the last visible line.
• System Information
  • Database version was missed.

Features and improvements:

• Online Support Desk - a new and avanced utility with an easy-to-use graphical interface to enable users a fast, easy and direct communication with Technical Support, receive News from Conquest Software Solutions and keep your SQLDetective and its add-ons up-to-date with its auto-update feature.
• Movie Navigator - a new feature in Icon Dictionary providing a easy navigation through all flash based tuturial movies - currently already over 40 !! - and displays educational movies via an easy-to-use graphical user interface. This tutorials will provide a new and fast way to explore and learn the basics of SQLDetective, its user interface, main tools and special tips & tricks in a very short time.
• Clear SQL - contains a new FlowChart feature that flowcharts all the subroutines in a PL/SQL package, a stand-alone procedure or block of code and displays them as a set of HTML-wrapped .jpg/.bmp/.gif/.png files.
• SQL Editor - the “Prompt bind variables before execute” setting has been added to the Bind Variables page.
• Object Navigator – generates a select count(*) statement for selected objects (tables, views, snapshots). The Pin/Unpin button is not shown for a named scene.

Bug Fixes:

• Core
  • Losing a database connection might cause the program to crash.
  • Commited all datasets of open sessions on a selected session commit.
  • Table Wizard, View Wizard, Materialized View Wizard were displayed in Task Bar with an object comment.
  • “Find Matching Pairs” caused "Access Violation" error on an empty editor.
• Object Navigator
  • The Add to Scene menu item did not list open scenes.
  • After deleteting an object in ObjectSelector, the number of objects was displayed incorrectly.
  • Switching between scenes made changed their status.
  • Changes such as: column width, position, and visibility did not save to a scene on exit of the application.
  • Ctrl+Click removed selection from the last selected node after a some pause.
  • Did not display an object's properties in ContentSelector for Refresh Groups and Rollback Segments.
  • Did not refresh ContentSelector on a scene object close.
• SQL Editor
  • Did not save the "Suspend On Error" checkbox status.
  • "List index out of bounds" error might occur on opening of Code Insight.
  • "Grid index out of bound" error might occur when the user canceled a statement execution with bind variables.
  • Double-click on a grid column caption caused "Access Violation" error when the dataset was not active.
• Stored Program Editor
  • Did not prompt to save changes made in the code when the database connection was lost.
  • Reload did not refresh information on the Errors and Message tab.
  • Did not display an execution time on the Execution Result tab after debugging a stored program.
  • Executing a stored program that returns a CLOB value caused "Access Violation" error.
  • Double-click on a sub-program of a package opened Stored Program Editor but did not navigate to the sub-program in the code.
• Table Wizard
  • List of columns was not focused on the Columns node selection.
  • Did not show a list of columns for some object tables.
  • Did not prompt to post changes on closing.
• Storage Manager
  • Did not display sorting in the Status Bar and sorting icon on column captions.
  • Could not filter and sort columns displaying size such as Size (MB), Used (MB).
• Smart Dataset
  • Export Data might cause "Bookmark not found" error.
• Fast Copier
  • Doubled sessions in the Session List on auto-open.
• Data Dependency Analyzer
  • Dataset Manager did not edit and apply filters.
• Trigger Wizard
  • Code Explorer did not show all PL/SQL variables.
• Extract DDL
  • Missed an object owner for columns based on an object type.
• Icon Dictionary
  • Could not select a Shortcut Schema except for the SQLDetective schema.

Click here to see Release Notes for ver. 2.1.1 - 3.3.1.