SQLDetective 3.3.1 introduces new features, improvements and bug fixes.

... top

Enhancements and improvements:

• SQL Editor
• New automatically saved SQL History with detailed information such as: statement execution start time, finish time, elapsed time, number of executions. Navigates and edits statements, finds by content, saves, prints and deletes selected statements. Provides a wide set of filters, sorting and options.
• Executes statements from the editor in SQL*Plus by single click.
• Improved data output for NUMBER columns in the SQL Output tab
• Suspends/Resumes script execution manually or on a bug occurrence.
• Data Grids
• Sorts data on Local by column header click.
• Displays record numbers. The feature can be set in Preferences.
• Support for multi-cell selection. Copy, Cut to Clipboard and Clear can be performed on the selected cells.
• Copies selection to MS Excel, XML, HTML, CSV.
• Performance of Select All improved.
• Storage Manager
• Relocates/moves multiple objects.
• Improved object location.
• Data Dependency Analyzer
• Filters list of objects in tree by TYPE and NAME.
• Support for SYNONYMS.
• Import and Export Data
• Added export to HTML and Clipboard.
• Supports exporting selected cells in data grids.
• “Auto column match by position” setting added.
• Code Editors
• Optimized sending highlighted statements from Stored Program Editor to SQL Editor. For example, if a statement has pl/sql variables, the program transforms them to bind variables while sending.
• Object Navigator
• ContentSelector displays Datafiles, Objects and Quotes for the selected tablespace.
• Relocates/moves multiple objects.
• Describe Object
• All describing objects open in the single window.
• Prints selected objects.
• Consumer Group Wizard
• Displays users belonging to a CONSUMER GROUP.
• Query Builder
• Support for SYNONUMS and MATERIALIZED VIEWS.
• Preferences
• Color Schemas added for the Code Editors.
• The Dataset Editors page is split into the LOB Objects, Smart Dataset and List of Values pages.
• “Hide Information Panel on successful compile” setting added to the Code Editors | Stored Program Editor page. If the setting is on, the Information Panel hides on successful compile of a stored program. The default setting is off.
• “Number of records fetched at one time from the database” setting is added to the Dataset Editors page.

Bug Fixes:

• Object Navigator
• Could not create a new object if the particular folder was not open.
• Expanding the table partitions folder failed on Oracle ver8.0.
• Could not locate a tablespace from ContentSelector in ObjectSelector.
• “Copy to SQL Editor” ignored text highlighting.
• Clear SQL (SQL Formatter)
• Ignored the indenting value.
• Lowercased some keywords when Uppercase was expected.
• The option General Layout | Header | Enable did not work properly.
• Find Object
• Search for invalid objects returned valid clusters.
• Smart Dataset
• Object reopen did not refresh the status bar.
• Trigger Wizard
• Always displayed only the last error in a trigger body.
• Index Wizard
• Newly created partitioned index type was displayed incorrectly.
• SQL Editor
• Number of successful and failed statements on a script execution calculated incorrectly if the script had an error.
• Oracle Documentation Browser
• Second open of the tool unselected all previously selected books.
• Export and Import Data
• Exporting an empty table might cause an error.
• Datafile Wizard
  • The Apply button became inactive on a datafile size change.

SQLDetective 3.2.1 introduces new tools and utilities, numerous usability improvements and bug fixes.

... top

Features and Benefits:

• Resource Plan Wizard - a powerful Oracle database version-dependent graphic interface with easy-to-use controls for working with Oracle resource plans. Use resource plans to define rules or directives and apply them to consumer groups.
• Consumer Group Wizard - a powerful Oracle database version-dependent graphic interface with easy-to-use controls for working with Oracle consumer groups. Use resource consumer groups to group user sessions together by resource requirements.
• Schema Analyzer - a graphic tool for collecting statistics, validating structures and listing chained rows of tables, table partitions and sub-partitions, indexes, index partitions and sub-partitions and clusters.
• SQL Editor enhancements
• Browses multiple queries in the various grids of the Data tab without the need to open several SQL Editor windows to browse different queries, thereby limiting the number of open windows and simplifying the GUI.
• Additional supported SQL Plus commands: SET SERVEROUT, SET HEADING, SET COLSEP, SET LINESIZE, SET LONG, SET NEWPAGE, SET PAGESIZE, SET TERMOUT and SET WRAP.
• Auto fits columns by data, title and data and title.
• “Display the Result pane above the Editor” setting added to the SQL Editor page of Preferences to control, where the Result panel is shown. If checked, by default, it is displayed above, otherwise – below.
• Added ability to change data tab order by drag&drop
• Object Navigator enhancements
• Improved object selection in ObjectSelector tree. Select a single object or a range of objects with a mouse click, as done in Windows Explorer.
• Actions such as: Open Object, Browse Data, Extract DDL, Export Data, Drop Object, etc. support a set of selected objects in ObjectSelector tree.
• Added ability to copy a single or selected objects name to the Clipboard.
• “Generate SQL” support for a set of selected objects in ObjectSelector Tree.
• “Analyze Data Dependency” menu item added to the ObjectSelector popup menu. This feature opens the Data Dependency Analyzer with the object selected in tree.
• Added truncate for table partitions and sub-partitions.
• Smart Dataset enhancements
• Added ability to browse and modify multiple tables/views/mat.views in different tabs.
• Added Dataset Manager (ColumnSelector and FilterSelector as in Object Navigator). This utility facilitates the customization of the visibility and position of dataset columns and the definition of filters and sorting using the “Query By Example” feature.
• Improved performance by untying from the Object Navigator tree.
• Opens all objects in a single window, and can be changed in Preferences, limiting the number of open windows and simplifying the GUI.
• Added ability to open and re-open objects.
• Data Editors (SQL Editor (Data tab), Object Navigator (Data and Objects tab) Smart Dataset, LOV) enhancements
• Data sorting by column header click. The first click sorts data ascending; the second click on the same column sorts data descending; and the third click cancels sorting.
• “Sort Ascending” and “Sort Descending” menu items added to the “Dataset | Query By Example” group of the Main Menu and popup menus.
• Auto fits columns by data, title and data and title.
• Prompts to post not posted data, if any, when the user commits changes.
• Code Editors (SQL Editor, Stored Program Editor, Trigger Wizard) enhancements
• Added “Find Match Pair” feature to the editor. This feature finds pairs of pl/sql reserved words such as: begin..end, if..end if, while..end loop, etc. and brackets.
• Stored Program Editor enhancements
• Displays compile-time warnings for Oracle 10g, making programs more robust by highlighting potential problems that are not severe enough to raise an exception, but may result in run-time errors or poor performance.
• Added ability to change tab order (stored program tab) by drag&drop
• Code Insight enhancements
• Added ability to display PUBLIC synonyms. The user can select the new option in Preferences in the Code Editors | Code Insight page.
• Improved performance.
• Displays a list of columns after typing dot after “:NEW” and “:OLD” reserved words in Trigger Wizard.
• Preferences enhancements
• Workspace page added to the General group. Settings on the new page control restoring windows, their size, position and state.
• “Remember window size and position” setting was removed from the General page – replaced by the Workspace setting.
• File extensions can be associated with SQLDetective.
• “Show Errors” setting added to the Extract DDL page. When the setting is on, the SHOW ERRORS command will be added after the CREATE OR REPLACE statement.
• Explain Plan, the SQL Editor Explain Plan tab enhancements
• Added ability to save to a file, print and copy to clipboard the explain plan result tree.
• Find and Replace Dialog enhancements
• Support for regular expressions.
• Schema Extractor
• Provides ability to generate DDL separated into one file per object type.
• Describe Object enhancements
• Added ability to drag&drop content (column name, sub-programs, object name, etc.) to the SQL Editor.
• Oracle Documentation Browser enhancements
• The Database Documentation Library add-on renamed to Oracle Documentation Browser.
• Added ability to specify the folder where index files are located.
• Open Database Object enhancements
• Session List added to switch between open sessions.
• Improved GUI.
• Session Navigator enhancements
• Added Dataset Manager to customize the visibility and position of columns and to define filters and sorting.
• Filters drop-down removed – replaced by Dataset Manager.
• Test SQL
• Removed from the application - replaced by SQL Editor. All features of Test SQL, especially the Bind Variables page, now available in SQL Editor.

Bug Fixes:

• Object Navigator
  • WinMenu key did not work
  • “Generate SQL | Create" did not work properly for constraints
  • “Save As” scenes may work incorrectly.
• SQL Editor
  • Opening a big script file took a long time.
  • Statement execution time was doubled.
  • Captured focus from active window after long-running statements execution.
• Stored Program Editor
  • Opening and closing of many stored programs may cause the wrong tabs to appear.
  • Horizontal splitter sometimes worked incorrectly.
  • VCS tool button was not active.
  • Code Explorer showed two bars (green and blue) for the same control structure.
  • Code Explorer considered the END of a package specification as a variable.
• Schema Extractor
  • Sometimes generated foreign keys before primary keys.
  • Added OVERFLOW clause for IOT tables.
  • Unique indexes produced by primary keys were generated twice.
  • Did not include TABLESPACE and COMPUTE STATISTICS clauses for indexes.
  • Wrong file extension applied for templates.
  • Reset settings on session change.
• Clear SQL
  • Syntax Check raised an error when the statement did not end with ‘;'
  • Raised AV and Session Navigator did not open when SQLDetective's root folder was read only.
  • Did not recognize “!=”.
• Session Navigator
  • Filters “Same User” and “This user” did not work properly.
  • “odsOpenCursor Cannot perform this operation on closed dataset” error caused when the user did not have sufficient access rights to system views.
  • Current Statement sometimes worked improperly on Oracle ver. 8.1.7-10.2.
  • Autorefresh unchecked selected sessions.
• PL/SQL Profiler
  • Stopped profiler for the active session in Object Navigator instead of the active one in PL/SQL Profiler.
• Oracle Documentation Browser
  • Caused AV when Internet Browser is not installed.
• Server Side Installation
  • Preview might open an empty file.
• Tablespace Wizard
  • Could not locate partitions and sub-partitions in Object Navigator tree.
• External Tools
  • Click on Select Folder for the Working Dir caused AV.
• Query Builder
  • Removing NULL from the Formula field caused an error.
• Export and Import
  • Export to PDF sometimes shortened column widths.

---

SQLDetective 3.1.1 introduces new tools and utilities, significant enhancements and improvements.

... top

New tools and utilities:

• Storage Manager ( add-on 15 ) – Monitors and manages tablespaces, datafiles, segments and quotes in the database instance. It provides an easy to use interface to create, modify, change status, coalesce and drop tablespaces; to create and change the status of datafiles; to relocate and move objects; to create, modify and delete quotes; to show different tablespace information such as: used, free and max size; free space; objects etc.
• Tablespace Wizard - a powerful Oracle database version-dependent graphic interface with easy-to-use controls for working with Oracle tablespaces.
• Rollback Wizard - a powerful Oracle database version-dependent graphic interface with easy-to-use controls for working with Oracle rollback segments.
• Datafile Properties – creates and modifies Oracle datafiles.

Significant enhancements and improvements:

• Stored Program Editor
• Opens multiple objects such as: procedure, function, package, package body, object type, object type body, java source under separate tabs of one window.
• Features a new customizable bottom-side panel with information such as: compilation errors, pl/sql debugger watches, breakpoint and call stack, DBMS Output, HTML Output, REF Cursor Output and Execution Result.
• New Stored Program Execution dialog generates an anonymous PL/SQL block for stored program execution and debugging.
• Execution can be performed in a separate session to prevent session blocking.
• Execution can be interrupted by user request.
• Modify stored objects and files without being connected to the database.
• Allows the opening of files with stored programs from OS Windows.
• Incorporates a straightforward interface to create a new stored program.
• Improved usability of stored program execution and debugging. Displays execution results such as: execution start, finish and total time; and errors in the Execution Result tab.
• Improved Code Explorer with new Code Section.
• PL/SQL Debugger
• Improved graphical user interface and performance eliminates the need to switch between multiple windows - all debugging information such as: watches, breakpoints, call stack and execution results are included in one window.
• Easy to start and stop debugging.
• Easy to add, modify and delete watches and breakpoints.
• Icon Dictionary
• Customizes visibility and flat property of all toolbars in the application.
• Customizes visibility and position of all buttons on a toolbar.
• Added the Shortcut Schemas drop-down to select the shortcut to the predefined schema.
• Added Icon Filter and Action Filter drop-downs, to filter the icon list by visibility of icons and by shortcut availability.
• Application popup menus support “Education Mode”.
• Added missing and new utilities and tools.
• Code Insight
• Lists data on a separate thread to prevent the application from blocking.
• Shows the list of columns in SELECT, WHERE, ORDER BY and GROUP BY clauses without typing a table alias and dot.
• After FROM and INTO clauses show only tables, views and synonyms.
• Added to the Main Menu and Main Toolbar.
• Improved performance.
• Connection Window
• The Connect As column added to the list of last connections.
• Last Connections can be sorted (ascending, descending) by any column in any order.
• Preferences
• Added new preferences for customizing Storage Manager, Stored program Editor and Export Data.
• Main Toolbar customization feature moved to Icon Dictionary.
• SQL Editor
• The Find button added to the Page List to search for text within statements.
• Export and Import Data
• The Commit option has been extended.
• Customize Toolbar
• Removed from the application - replaced by Icon Dictionary functionality.
• Debug Runtime Information
  • Removed from the application - replaced by Stored Program Editor.

---

SQLDetective 3.0.2 introduces one new tool, numerous usability improvements and bug fixes.

... top

Features and Benefits:

• Icon Dictionary – a new tool that simplifies the learning and understanding of the SQLDetective user interface, by providing quick descriptions for each icon in the application. Provides easy to use shortcut key customization.
• Recycle Bin - Oracle 10g introduced the Recycle Bin, a logical entity that holds deleted tables and associated objects (indexes, constraints and triggers). All deleted objects are kept in the Recycle Bin. These objects can be retrieved from the Recycle Bin or be deleted permanently by using the PURGE command. To access the deleted objects, use the ObjectSelector's “Recycle Bin” folder.
• Command Line Options – a new feature that lets you start SQLDetective with command line parameters such as: CONNECT, EXECUTE, FORMAT_SQL, DONT_RESTORE_WORKSPACE, etc. For example, FORMAT_SQL command lets you format sql files using the ClearSQL's Formatter in command line mode without launching SQLDetective's IDE.
• Object Navigator enhancements
  • Generate SQL - a new popup menu item with a list of sub-items that generates different types of SQL commands for the selected object in the ObjectSelector, like: SELECT (*, ALL, with ROWID), INSERT, UPDATE, DELETE, CREATE and DROP.
• SQL Editorenhancements
  • Improved Popup Menu that is displayed when the object from the ObjectSelector is dragged and dropped to the editor.
• PL/SQL Debugger enhancements
  • Improved usability.
• Session Navigator enhancements
  • ClearSQL formatter applies to SQL statements shown on the Current Statement and Open Cursor pages.

Bug fixes:

• Core
  • The program did not connect to a database after opening the Connection Setting dialog.
  • An error might occur after opening several windows and switching between different open sessions.
  • The program might hang when the connection is lost.
  • Export data in Table and View Wizards caused an Access Violation error.
  • DDL for queue tables always included the owner and comments for the table even if the appropriate settings were off.
• Object Navigator
  • Invalid dimensions displayed like valid ones.
  • Could not open objects of a scene from another session.
  • Captions for constraints, object columns, references and dependent objects in ContentSelector tabs were displayed incorrectly.
  • “Create New…” feature caused an error when the Users, Tablespaces, DBA Roles, Session Roles, and Rollback Segments folders were selected in ObectSelector.
  • The “Date Modified” property of a scene did not change when the scene was saved.
  • Working with multiple scenes might cause an error.
  • After compilation, dependent objects displayed incorrect totals.
  • Compilation dependent objects on which the connected user has no access rights displayed incorrect error messages.
• ClearSQL (SQL Formatter)
  • Could not format stored programs ending with the ‘/' character.
  • Could not format sql statements ending with comments.
  • Analyze code did not work properly.
• SQL Editor
  • Did not open the Ref Field Editor for Ref fields in a dataset.
  • Changing DBMS_OUTPUT buffer size did not apply automatically.
  • “List index of bound” error occurred on closing the program when the dataset was open.
  • Access Violation occurred on activation of the HTML tab if Internet Explorer was not installed on the PC.
  • Did not recognize PURGE command.
• Smart Dataset
  • QBE features did not function after printing a dataset's data.
  • “Record Count” displayed an incorrect value on the closed dataset.
• Oracle Documentation Browser
  • Did not select new books after building indexes.
  • After closing the window, it remained in the memory.
• Find Objects
  • Did not remove a closed session from the list of sessions.
  • Did not clear the search result after closing a session.
• Explain Plan
  • The “Search” button was not active.
  • For Oracle 10g, the list of plan tables displayed plan tables that were dropped into the Recycle Bin.
• PL/SQL Profiler
  • “0.0 is not a valid timestamp” error might occur on delete a Run.

---

SQLDetective 3.0.1 introduces new features, enhancements and numerous performance and usability improvements.

... top

New tools and utilities:

• ClearSQL ( add-on 14 ) - a code review and quality control tool for Oracle PL/SQL development, built around a code analyzing technology and an advanced code editor. ClearSQL improves the quality of PL/SQL code while increasing the productivity of the software team.
• Materialized View Wizard - a powerful Oracle database version-dependent graphic interface with easy-to-use controls for working with Oracle materialized views (snapshots): relational, partitioned, index-organized, cluster-organized and external .
• Materialized View Log Wizard - a powerful Oracle database version-dependent graphic interface with easy-to-use controls for working with Oracle materialized view logs (snapshot logs).
• Dimension Wizard - a powerful Oracle database version-dependent graphic interface with easy-to-use controls for working with Oracle dimension.
• Outline Wizard - a powerful Oracle database version-dependent graphic interface with easy-to-use controls for working with Oracle outlines.
• Policy Group Wizard - a powerful Oracle database version-dependent graphic interface with easy-to-use controls for working with Oracle policy groups.
• Refresh Group Wizard - a powerful Oracle database version-dependent graphic interface with easy-to-use controls for working with Oracle refresh groups.
• Queue Wizard - a powerful Oracle database version-dependent graphic interface with easy-to-use controls for working with Oracle queues.
• External Tools – allows a user to define external programs to quickly run them from the SQLDetective's IDE.
• Compile Dependencies – provides an easy-to-use interface to compile dependencies of an object.

Other significant enhancements and improvements:

• Object Navigator
• Completely new IDE consisting of 5 panes: ObjectSelector, ContentSelector, SceneSelector, ColumnSelector and FilterSelector.
• The ObjectSelector shows Oracle objects grouped by type in a hierarchical tree view. Access an object's features with a context-sensitive pop-up menu; drag & drop an object to Code Editors, Query Builder and The SceneSelector; navigate easily using “Back to…”, “Forward to…”, “History List”; handle operations such as: open, compile, extract DDL, export, drop, etc. on a set of highlighted objects.
• The ContentSelector is a container for opened objects in the ObjectSelector. Use drag & drop or popup-menu to add an object to the container. Depending on the object type, browse object data, see its properties, DDL, etc.
• The SceneSelector displays a list of SCENEs. A scene is a named workspace of the Object Navigator that contains objects, pane sizes and positions, the scene description and its properties. Use this feature to quickly access frequently used objects and to open several scenes.
• The ColumnSelector lists a dataset's columns. Use it to hide/show/move columns using drag & drop and Single Click. The customized dataset can be saved to a scene.
• The FilterSelector lists user-defined object filters. Create different object filters using the easy-to-user QBE Editor. The active filter will be applied automatically to open objects in the ContentSelector.
• The following folders have been added to the Schema node: “Materialized View Log”, “Outline”, “Dimension”, “Queue”, “Policy Group” and “Refresh Group”.
• The “Tablespace objects” folder has been added to the Tablespace node.
• SQL Editor
• Combines a set of features and consists of the following tabs: Output, Data, Statistics, Explain Plan, DBMS Output, HTML Output. Depending on the executed statement, the result is sent to the most logical tab (When the “Smart Output” setting is ON).
• New “Executed Statements” pane added to the editor. Provides easy access to executed statements, save and print out.
• Execute a single statement from a list of statements, divided by empty lines.
• Added setting: “Skip to the next statement after execution”.
• Export and Import
• New IDE provides export and import data from a set of selected objects to a single file.
• Save and load user defined templates.
• Improved performance.
• Schema Extactor
• Added “Filters” tab. defines filter criteria by name, status, etc.
• Added “Extraction Order” tab adjusts the order of object extraction.
• Added “Preview objects before extract” setting displays the list of objects to be extracted.
• Save and load user defined templates.
• Schema Compiler
• Added “Filters” tab defines filter criteria by name, status, etc.
• Save and load user defined templates.
• Explain Plan
• Open “Query Builder” button added.
• Multi-page editor added.
• Table Wizard
• Supporting “Queue Tables” added.
• “Data” page added.
• Preferences
• “Reset Current” button added.
• “Remember window position and size” setting added to the general page.
• "Remember open statements" setting added to the Code Editors page.
• Find Object
• New IDE provides search for objects in a set of selected schemas and types.
• Code Insight
• Improved performance.
• Others
• Improved IDE for the following tools and utilities: Data Dependency Analyzer , Fast Copier , View Differences , Session Navigator , PL/SQL Profiler , Action Output and Customize Toolbar.

---

SQLDetective 2.5.2 introduces one new tool, enhancements and numerous usability improvements.

... top

Features and Benefits:

• PL/SQL Profiler – a new powerful graphical tool that provides an easy-to-use interface to profile PL/SQL code and identify performance bottlenecks . Application developers can use code coverage data to focus their incremental testing efforts (requires Oracle 8.1.5 or higher).
• Shortcut Customization – change and add your own shortcuts to suit your working style . Users can assign keyboard shortcuts to frequently used commands and delete keyboard shortcuts as well.
• Customize Toolbar – new utility that provides an easy to use interface to customize the visibility and order of the toolbars buttons for the following tools and utilities: SQL Editor, Stored Program Editor, Test SQL, Query and Dataset Builder, Explain Plan, Report Generator, Session Navigator, PL/SQL Profiler, Query Dataset, Smart Dataset.
• Object Navigator enhancements
  • MY SCHEMA – a new element of the tree view that speeds up and simplifies access to the objects of the currently logged user's schema.
• QUICK NAVIGATION – a set of buttons: Forward, Back, History and Up One Level, that provide a comprehensive interface for quickly navigating between operated elements of the tree view, as in Microsoft Explorer.
• CASCADE CHECKBOX added to the confirmation dialog.
• CONTEXT and DIRECTORY folders have been moved to the session level.
• NEW SESSION, CLOSE SESSION, RECONNECT SESSION items added to the back menu.
• Code Insight enhancements
• Improved speed of execution time.
• New settings added to meet user requests.
• Support for complex data types such as: record, type and row type.
  (This feature is available in Stored Program Editor and Trigger Wizard and
  requires enabled Code Explorer).
• Cancel the long running process by clicking ESC added.
• SQL Editor enhancements
  • STATEMENT NAVIGATION and EXECUTION – a new feature that allows easy navigation between statements in an editor's page and execution of the statements separately or as one script.
  • Using QUERY BUILDER improved.
• Stored Program Editor enhancements
• New setting “Show Specification and Body divided by tabs/splitters” added, that allows the user to select the most convenient representation of the specification and body editors.
• Stored object information has been extended in the Status bar.
• Logon Window enhancements
  • Interrupting the process of restoring session's workspace by pressing ESC added.
  • Holding SHIFT while logging on omits the process of restoring session's workspace.
• Dataset Editors enhancements
• Support for Cursor field type added.
• Calendar Editor added for editing DATA columns.
• Describe Object enhancements
  • Sorting data by clicking on the column header added.
  • Find and print text added.
• Object Privileges enhancements
• Refresh button added.
• Preferences enhancements
  • “Decimal Separator setting added.
• Query Dataset enhancements
• Duplicate button added.
• For non-SELECT statements, offers option to execute them in SQL Editor.
• Table Wizard enhancements
  • Improved performance of reading table information.

---

SQLDetective 2.5.1 introduces new tools, utilities, enhancements and numerous performance and usability improvements.

... top

New tools and utilities:

• Session Navigator ( add-on 13 ) - Monitors and manages sessions in the database instance and is used to view a different session's information such as: open cursors, locks, event waits, long operations, transactions, input and output, statistics etc. It provides a wealth of settings and allows the user to kill and disconnect sessions, and to enable and disable SQL tracing for the selected session(s) .
• Profile Wizard - a powerful Oracle database version-dependent graphic interface that offers easy-to-use controls for working with Oracle profiles. The program supports PROFILE type.
• Import Data - provides an interface for importing data from Char Delimited, XML, Excel and internal formats into a table.
• QBE Editor – a visual utility that is used to define filter conditions and sorting for datasets. It simplifies defining QBE and speeds up data filtering and sorting in a dataset.
• Expression Builder – a visual tool that speeds up and simplifies building expressions such as WHERE, HAVING, GROUP BY, ORDER By etc. in the Query Builder, QBE Editor and Smart Dataset.

New features and Improvements:

• Dataset Editor
  • Browse and modify dataset data in Single Record mode
  • Quick navigate to a dataset column and copy its name
  • Clear QBE filter and sorting
  • Improved browsing of datasets with large numbers of records
• Stored Program Editor
  • Added one-key switching between implementation and specification of a package's or type's member
  • Improved the Code Explorer
• Preferences
• Save and load settings to a preferences file
• Newly added Session Navigator page with a number of settings to customize the Session Navigator
• The "Include parent objects" setting added to the Extract DDL page
• The "Use DBA dictionary view if available" setting added to the Session page
• Improved "Date Format" setting
• New settings to customize the Dataset Editor added to the Dataset Editor page
• A number of new settings to confirm and prompt the user's actions
• Schema Compiler
  • A user can select more than one schema to be compiled
  • Invalid objects are shown on a new tab-page
  • Improved the graphical interface
• Export Data
  • A new graphical interface that exports to the following formats: SQL Insert Script, Microsoft Excel, XML, PDF, Char Delimited and Internal
  • New Compress file checkbox added. This feature provides data compression in ZIP format
• Object Navigator
  • Profile folder added
  • New Columns folder added for materialized views
  • Improved filtering
• Logon Dialog
  • Handles the ORA-28001 (The user's account has expired and the password needs to be changed) error during logon to a database
  • Handles the ORA-28002 (The user's account is about to about to expire and the password needs to be changed) error during logon to a database
• Data Dependency Analyzer
  • A user can open more than one window, creating a multi-session tool. It provides new features for both Master and Detail datasets
• Test SQL
  • New dataset that supports all features of Smart Dataset 's dataset
• Query Dataset
  • A user can open more than one window. Its Statement Navigator and Command History are similar to SQL Editor's
• Explain Plan
  • A user can open more than one window. A new way to view and modify comments for a record of a plan
• Code Assistant
  • New templates of SQL and PL/SQL up to Oracle 10g added
• Code Insight
  • Filters the list while the user searches for the data
  • New object types added
• Group Action
  • Session column added
• Open Database Object
  • Long running processes can be broken
• Command History
  • Delete Statement and Clear Statement buttons added
• Query Builder
  • Calling the Expression Builder for building Where, Having, Group By, Order By clauses, formula etc added
• Oracle Documentation Browser
  • Pressing the Enter key in the "Text to find" editor starts the search process

Bug fixes:

• Object Navigator
  • Synonyms in the Dependences folder displayed incorrectly
• Extract DDL for tables
  • The Mapping, Compress, PCTTHERSHOLD, Compression parameters for index-organized tables were not handled correctly
  • A nested-table column name was not included in quotation marks
  • A column name in the PARTITION BY RANGE clause was not included in quotation marks
  • A REF table name was not included in quotation marks
• Dataset Editor
  • Cannot modify an LOB column with the name in quotation marks
  • Opening a table with an object column in Oracle 8.0 would cause AV
• Index Wizard
  • Hash partitions were not handled properly
  • Cannot create index based on a table if it's name is in quotation marks
• SQL Editor
  • Totals indicated wrong number of errors after execution of a script
  • The Output Window became focused after the execution of a statement
  • Execution time displayed incorrectly if it exceeded 1000 seconds
  • Commit did not perform after a DML statement while “Autocommit” setting was enabled
  • Searching for a text would cause AV
  • Totals was not shown after executing a script the second time
  • Page navigation problems fixed
  • Showing a large script in History Command would cause AV
• Connection Settings
  • Changing ORACLE_HOME would cause AV
• Query Dataset
  • The caret position changed after the execution of a statement
  • Did not show the error position after the execution of an invalid statement
• Query Builder
  • Restriction clause did not work properly for DATE columns
  • Problems of drawing links fixed
  • The Outer-Join clause was not built correctly
• Test SQL
  • Could not delete a page that was added automatically
• Code Insight
  • Would raise the “Undefined session” error when there was no active session
• Repository and Version Control System
  • Adding a stored program would cause truncation of the last char
  • Could not add a tablespace
  • Renaming a folder or project would cause an Oracle error
  • “Don't ask me again” setting did not work when creating a new folder
  • VCS functions did not work when there was no active session
  • Changing the “VCS Provider” setting from Built-in to another one would cause AV
  • Adding an object depended on the Extract DDL options
• Core
  • Fixed some memory leaks
  • Fixed several Access Violation errors

---

SQLDetective 2.1.1 introduces new features, enhancements and numerous performance and usability improvements.

... top

New features and tools:

• Version-dependent Object Wizards: Table Wizard, View Wizard, Trigger Wizard, Collection Wizard, Index Wizard, Sequence Wizard, Cluster Wizard, Index Type Wizard, Operator Wizard, Job Wizard, Policy Wizard, Context Wizard, Library Wizard, Directory Wizard, Database Link Wizard, Synonym Wizard, Constraint Wizard, User Wizard, Role Wizard and Object Privileges
• Support for relational, object, xml-type, index-based, cluster, external and partitioned tables
• Support for relational, object, and xml-type views
• Support for object, nested table, varray, refs, and xml-type column types
• Support for range, hash, composite, and list partitions
• Analyze Object
• Oracle Documentation Browser
• Dataset Builder
• Export to Microsoft Excel, XML, PDF
• Export/Import Repository Data
• HTML Editor
• BLOB, CLOB, Nested Table, and REFs Column Editors
• Oracle E-Business Suite Object Description
• Rename Object
• Schema Compiler
• Schema Extractor
• Storage Editor
• System Information
• Truncate Object
• View Differences

Other significant enhancements and improvements:

• Integrated Development Environment
• New customizable main toolbar
• New context-sensitive Online Help in Microsoft HTML Help format
• Added ability to quickly reconnect an Oracle session
• Added "Show only an active session's windows" workspace feature
• Added "Fit overlapped windows in workspace" workspace feature
• Improved workspace saving and restoring
• Improved Compile Object feature
• Additional set of new preferences
• Object Navigator
• Increased speed of opening and refreshing folders
• Improved re-query of referenced and dependent objects
• Repository and Version Control
• Customized Smart Dataset can be saved to Built-in VCS
• Added ability to select a project when adding an object
• Added ability to select a folder when saving a customized Smart Dataset
• When the “Auto-commit” option is off, the user is prompted to save changes
• Object source text can be viewed via repository tree
• Code Editors (Stored Program Editor, SQL Editor, Test SQL, Query Dataset) added features:
• Text Outdent and Text Indent features
• Comment and Uncomment block and lines of text features
• Insert File feature
• Find Declaration feature
• Dataset Editors (Smart Dataset, Query Dataset, List of Values)
• Long running query can be canceled
• Query-by-Example supports the IN and BETWEEN clauses
• SQL Editor additions
• Find text in the output window
• The “Read HTML Output” setting
• Test Window
• HTML Output tab has been added to show web server output
• Improved execution and debugging of stored programs
• PL/SQL Debugger addition
  • Run to Cursor feature.