Enhancements and improvements

• Core
• Improved object alteration and error handling in Object Wizards.
• Added ability to drop a datafile of a tablespace from within ObjectSelector as well as in Storage Manager and Table Wizard. The feature is available for Oracle version 10.2 and above.
• New option "General -> Session -> Only one connection per instance" - if checked, allows only one database connection per SQLDetective instance.
• New setting "General -> Extract DDL -> Include BYTE/CHAR specification" - if checked, includes BYTE/CHAR specification for columns in ObjectSelector, Object Wizards and DDL extraction. The feature is available for Oracle version 9.2 and above.
• New setting "General -> Session -> Indicate "Connect As" (SysDBA, SysOPER) in the connection string" - if checked, displays SysDBA/SysOPER in the database connection string in the session drop-downs.
• "Standalone" windows such as OSD, TKProf Shell, Report Generator, etc in maximized state are shown in the main window as child windows.
• Object Navigator
• Generates DROP/ENABLE/DISABLE statements for primary/unique/foreign key dependencies.
• Synchronizes ObjectSelector's folders on refresh of ContentSelector datagrid.
• Searches for objects in ObjectSelector's collapsed folders.
• Validates ObjectSelector's object folder if an object has been created/altered/dropped in SQL Editor.
• Validates ObjectSelector's object dependant folders on object alteration/dropping.
• Displays primary/unique/foreign keys as dependent objects in the Dependences/References folder.
• Improved performance and response time of ObjectSelector.
• New column DATA_DEFAULT in the Columns tab of ContentSelector displays table default value as plain text.
• UNUSABLE, UNIQUE and IOT - TOP indexes and MAT.VIEW tables are shown in ObjectSelector with specific icons.
• New menu item "Select Unusable" in ObjectSelector's popup menu - marks all unusable indexes in the Indexes folder.
• Prints and refreshes object properties.
• Background job execution.
• SQL Editor
• Executes statements in the background (creates separate background session)
• New setting "Auto Explain Plan" on the Explain Plan tab - if checked, automatically runs Explain Plan for the executed statement.
• New setting "Display zero values" on the Statistics tab - if unchecked, doesn't display statistics with zero values.
• Prints and saves statistics result to TXT/HTML file.
• Saves Statistics Configurator settings to file.
• Searches for text in Statistics Configurator.
• Execution Detail Status of SQL Execution History displays for scripts a number of successfully/failed/broken and totally executed statements.
• New commands: BROWSE - for the selected in the editor object (table/view/mat.view/synonym) opens a read only dataset; EDIT - for the selected in the editor object (table/view/mat.view/synonym) opens an editable dataset.
• The Save/Save As buttons become enabled only when text in the editor has been modified.
• Export Data
• New format "Fixed Field Spacing"
• Exports LOB fields to separate files.
• Improved "MERGE Script" export.
• Became a non-modal window - it's possible to switch between the Export Date window and other application windows.
• New ability to define a WHERE clause for all exporting objects individually.
• New navigation buttons: First and Last - provides a more convenient way to navigate pages.
• New setting "Don't create empty files" - if checked and the exporting object has no records, doesn't create an empty file.
• New setting "Prefix filename with export order" - if checked, adds object export order number to file name.
• New setting "Create "run.sql" launch file" - if checked, generates script file intended for running all exported sql files.
• New setting "Statement delimiter" - a dropdown with "/" and ";" sql statement delimiters.
• New setting "Show the process in percentage-of-completion (executes "select count(*)..."" - if checked, shows the process of exporting in % by executing an additional statement for record counting. It's highly recommended to switch the setting off for datasets that are based on long running queries.
• New button Count in the "Data Filter" page. Added to avoid automated dataset record counting for better performance.
• Import Data
• Became a non-modal window - it's possible to switch between the Export Date window and other application windows.
• New navigation buttons: First and Last - provides a more convenient way to navigate pages navigation.
• Compare Databases/Schemas/Objects
• New option "Compare object privileges only" - if checked, compares only object privileges for the selected database/schemas/objects
• New option "Include BYTE/CHAR specification" - if checked, includes BYTE/CHAR column specification in the synchronization script.
• New option "Ignore column order" in the table tab - if checked, compares columns by name instead of their order.
• New setting "Text case" - specifies synchronization script text case.
• New setting "Compare object synonyms" - if checked, compares object synonyms on the object comparison.
• "Row Count" group is moved to the table tab.
• Ignores quotes in object names.
• Improved comparison of constraints.
• Stored Program Editor
• Compiles a stored object with debug information within the editor (new button on the toolbar). New panel of status bar indicates if the object is compiled with debug information.
• By default, selects the execution of a sub-program that is currently active (where the mouse cursor is) in the Editor.
• Database Examiner
• Displays database properties information.
• Modifies system modifiable initialization parameters.
• Top Session Locator
• Click on a segment of the Top <N> Modules and Top <N> Users charts to highlight the corresponding sessions in the session grid.
• "Command In progress" column displays more descriptive information instead of displaying the command number.
• ClearSQL add-on
• New feature "Call Tree" - graphically displays a call tree for a standalone object or a subprogram of a package.
• Flowchart with ability to click on its segment and see the associated code.
• View Differences
• New graphical interface with ability to open multiple windows.
• Session Navigator
• SQL Trace can be run by using the system package DBMS_ SUPPORT with an ability to collect Waits and Binds.
• New column "Elapsed Time" on the "Long Operations" tab.
• Find Objects
• Searches for text in object and column comments.
• Server Side Installation
• Redeveloped graphical interface with an ability to select an ORACLE HOME.
• View DDL
• Improved graphical interface with an ability to view different DDLs in different tabs.
• Relocate Wizard
• Support for materialized view movement between tablespaces.
• Group Action
• Displays detailed information about object compilation errors.
• Storage Manager
• Added new fields to the Tablespace and Datafiles lists.
• Code Assistant
• Improved the "Find Text" feature.
• Describe Object
• New menu item "Refresh" - refreshes/validates all open objects.
• Preferences
• New setting in the Session page: "Enable the Commit checkbox in JOB dropping prompt window".
• Connection Settings
• Displays location of SQLNet.ora file for the selected Oracle Home and provides an ability to view it in the imbedded text viewer.
• OSD
• Improved paste from clipboard to the New Message window of the result of Explain Plan copied from the SQL Editor -> Explain Plan tab.
• QBD file type is added to the list of acceptable file types for OSD attachments.
• Datasets
• "Count Records" executes in a background process and can be interrupted.
• Grids
• Autofit column widths and data sorting.

Bug fixes

• Core
• Could raise an "Access violation" error when the application is made active after being inactive for certain time.
• OSD window forced to become foreground from the background on a new database connection.
• SQL Editor
• The window might close unexpectedly during statement execution; after that the application raises an "Access violation" error.
• Paste from clipboard by using a shortcut key did not work in Search tool of SQL Execution History.
• Ignored new entered bind variables when the "Keep column settings" option was enabled.
• Integer and floating point bind variable values were not properly validated.
• Object Navigator
• "Access violation" error might occur on open multiple procedures/functions.
• Stored Program Editor
• Could raise an "Access violation" error during window switching.
• "Boolean IN" subroutine parameter was detected incorrectly.
• Compare Databases
• Synchronization script was uppercased.
• PL/SQL Debugger
• Could raise an "Access violation" error during object debugging.
• Session Navigator
• Data on the "Long Operations" tab for the selected session was mixed with data of other sessions.
• Extract DDL
• Generated prompt 'Creating Constraints' for objects with no constraints
• Find Files
• Could not find text in files with long paths.
• Smart Dataset
• "Access violation" error might occur on connection lost.
• Code Insight
• Could hang the application after the 'connect by prior' clause usage.