Released: Sep 23, 2020

Atualizações na 5.1.1.361

Recursos

• Object Navigator
  • Connected sessions in the Object Navigator are now colored according to the selected database type.
  • If a database connection password expires soon or has already expired, both cases are now indicated in the “Change password” window.
• Find Objects - Removed Public schemas from the system schema list, so the Public schemas now remain visible when the “Hide system schemas” check box is enabled.
• Compare Schemas - Optimized the memory usage for schema comparison with a large...

Released: Mar 31, 2020

Atualizações na 5.1.1.316

Recursos

• Preferences - Removed the “Notify about AMS expiration” check box from the License Key page.
• Session Navigator - Added all missing fields to the Process tab and the most frequently used ones are now displayed by default.
• Code Editor - All occurrences of selected text are now highlighted in the Code Editor.

Correções

Core

• Fixed the error “Could not initialize taskbar. Error:-2147467263” when running SQLDetective on Windows Server with Citrix.
• Files in UTF-8 (with no BOM) and UTF-16 are...

Released: Nov 28, 2019

Atualizações na 5.1.1.239

Recursos

• Database Connection - Added new “Switch to a new connection in the active window” option which is enabled by default. When disabled, starting a new database session does not change the database connection in the active window.

Correções

SQL Editor

• Fixed history panel splitter.
• Splitter positions of the Dataset Manager and SQL History panels are now remembered and restored correctly.
• The token with leading ampersand in a string literal is now always recognized as a possible substitution...

Released: Oct 25, 2019

Atualizações na 5.1.1.212

Recursos

• Online Support Desk - The process of downloading updates is now indicated on the Windows taskbar.

Correções

Core

• The error “ORA-00933: SQL command not properly ended” is no longer raised on a script execution if a DDL statement contains an empty string.
• The error “FROM clause not found in SQL” no longer occurs on trying to execute a statement with the apostrophe in a q-notation.
• Fixed the highlighting of a literal if the opening bracket of a q-notation is followed by a break.
• A single...

Released: Oct 17, 2019

Atualizações na 5.1.1.210

Recursos

Core

• Oracle Client is now automatically downloaded and installed if no installation is detected on the PC.

SQL Editor

• Added the ability to search for text occurrences in the DBMS Output tab.

Compare Databases

• Improved the comparison of system generated objects.

Rename Object

• Added the ability to automatically rename tables indexes.
• Added the ability to rename tables and indexes of another user.

Dataset/Datagrid

• Focused cells are now always highlighted in datagrids.

Taskbar

• Applied...

Released: Jul 18, 2019

Atualizações na 5.1.1.160

Recursos

Code Explorer

• By default, the Code Explorer panel is now always open in the SQL Editor and Stored Program Editor.
• It is now possible to toggle the visibility of the Code Explorer panel for each module separately.
• The “Code Explorer” page was removed from Preferences.
• Added the “Toggle Code Explorer” command to the SQL Editor, Stored Program Editor, and Trigger Wizard pop-up menus.

Text Editor

• When there is no text occurrence of the searched text in the code, the user is no longer...

Released: Jun 27, 2019

Atualizações na 5.1.1.146

Recursos

Core

• Added the ability to execute an external SQL script file after logon. This behavior can be disabled at “Preferences > Session > Execute the file on logon.”
• Added the ability to change the password of the current user. The command “Change Password” is now available from the Session menu and from the Object Navigator pop-up menu.
• The startup window is now closed immediately after selecting an action.

Object Navigator

• Object properties now include general properties from the all...

Released: Jun 13, 2019

Atualizações na 5.0.1.182

Recursos

SQL Editor

• Improved workflow of automatic determination of execution plans.

Database Monitor

• Queries now run in a sequence, not in parallel threads.

PL/SQL Debugger

• Added the ability to view global variables.

Correções

Code Editors

• The cursor, when moved using the Ctrl+arrow keys combinations, no longer breaks on pointing to the dollar and number signs.

PL/SQL Debugger

• The error message “Unhandled exception occurred. Debugger will be terminated.” no longer appears after an Oracle...

Released: Apr 30, 2019

Atualizações na 5.0.1.159

Recursos

Object Navigator

• Added the ability to customize Ctrl+Click behavior for database objects.
• Added new options to “Preferences > Code Editor > Ctrl+Click on an object”:
  • Locate it in Object Navigator.
  • Open it in Object Wizard.
  • Open it in Describe Object.

Preferences

• Increased object name length to 128 characters.

Correções

Core

• Fixed fetching of LONG fields and extraction of DDL triggers and views.

Query Dataset

• The error “Out of system resources” no longer occurs on trying to run...

Released: Apr 18, 2019

Atualizações na 5.0.1.146

Recursos

Core

• SQLDetective can now connect to databases in MOUNT mode.
• Added the ability to connect to a database using Oracle Wallet.

Database Monitor

• Added the ability to perform SQL tracing using the DBMS_MONITOR package:
• The SQL Trace options are now opened in a separate window on enabling SQL Trace.
• Removed the SQL Trace options from Preferences.

SQL Editor

• Removed unnecessary synchronization options of the Data and Editor tabs from Preferences.
• The Data and Editor tabs are now always...