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.
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.
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.
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.
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.
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.
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
