We are proud to announce the release of our first 6.5 beta.
I hope you can all join us in using this release and giving us feedback.
We are still working on other issues that have been reported by our community and we will provide more builds in the new year.
Location of the build:
Issues resolved in this release:
Syntax highlight on error causes text to disappear
Support 11g keywords - Syntax highlight
Synax Highlighting for timestamp don’t work in Packages
View editor does not notice changes
View editor focus lost on apply changes
Saving DDL documents does not always ask for filename
Ignore trailing spaces when enter value in grid for number type
CodeEditor can not type after Ctrl+E
extract ddl for object displays in trigger editor
Find + does not work
Replace not working properly with regular expressions in Search/Replace window.
Scroll bar can’t move when do sort in the column page
CLOB editor scroll bar not going to end
Close button x is disabled after opening a file
AV occurs when Createing a new Constraint
File open dialog not resizable in ‘View Differences’
Issue with Export Data Spool Text
Server output tracing statements before the error code appears
Bring back the Quick Filter" i.e. old filter side by side with new filter in the DBX"
Empty cursor list causes ‘Index Out of Bounds’ in Run TAB
Open Object at Cursor not working in the Create Statement
Tab keystroke to select/complete the option in the dotlook/code completion list.
Add support for SEGMENT CREATION for Tables.
Multi lines dbms output is not highlighted completely in Spool
Close Code Editor when closing the last remaining tab - new preference included
Don’t press the save button your catalog’s will not be saved and you will not get a warning about it.
Session Browser to include Last Activity Timestamp
9i database hangs when certain SQL is ran, e.g. SELECT XMLELEMENT…
Strange behaviour in text selection with keyboard and mouse mixed
Cursor beyond EOF
Launch Profile Manager, SQL Tracker from SQL Nav app
Ability to navigate to table from an Index, just like it is possible to open index from table editor.
CLOB field doesn’t show as (null) after it’s deleted in data grid
Quoted object name is mixed up with normal object name in object selector
Smart Tab is not working correctly
Can’t debug the package when log on as non-DBA user
Should use = instead of LIKE in the queries to improve performance
split is set in code editor, then Text in code editor will disappear when apply preference.
SQL navigator hang when print code editor
OIDINDEX clause is duplicated when extract ddl for table
Problem cloning Table with CLOBs/BLOBs
Work with trace into in Debugger will cause AV
Reduce the cell spacing in the data grid
Include a DROP FORCE clause for type object
Data set is read-only if there’re brackets around the query
Open File windows to have the same list of file types
Options to change the behaviour of drag & drop view
Cannot start selecting text if mouse is clicked under the last line
Sorting doesn’t work in DataSet Viewer
Cannot make changes to both column name and type in the Table Editor
Ability to export selected rows
Various issues with BLOB, CLOB, etc. editor
Search string should be positioned at the top when object is opened from code search
Copy/Paste in block mode doesn’t work consistently
File type drop down doesn’t show text file .txt like in 5.5
Find and Replace does not work with some regular expressions
Find Recycle bin Objects is not disabled when Find Objects is running
Add the Schema Scope group box to Find Recycle bin Objects
Allow to stop Code Search when searching
Source Viewer in the Profiler doesn’t show the correct script
Preference to move/not move the currently executed query to the top
SQLNav should ignore the EOF character in tnsnames.ora
Nav hangs when updating a table row which is locked
Preference ‘Trim column width while pasting’ under Object Editors doesn’t work
When click show column, the column in the columns tab in the toolbox isn’t selected
Add Search feature for History pane
Add shortcuts to View Differences
Open exported data in an existing tab or new tab
OS Authentication - Display Schema name in DBX and DB Nav
Add a Node for Directories in DBNavigator tree
Date is cut off when export from data grid
The name field in Find Objects is too short to show long object name
New line character is added after insetting a template
Ctrl+left/right arrow doesn’t place the cursor at the right position
The few characters were cut off from the Date field in the Spool tab
On opening, allow auto sizing column name, in DESCRIBE window, to a size of the largest column name.
Add support for 10g syntax - NAN(Not A Number) and INF (Infinity)ORA-01722: invalid number
Improve support for large Data Sets in the data grid
run this query with fetch all option - select * from all_arguments, (select * from emp where rownum < 5); --> nav closes
Enhance DB Navigator - show additional Tablespace information and new node in tree for Data files
Trigger Editor: resize/dock details pane on the right/left/bottom
Remove 2GB file size limitation when exporting
extract of securefile LOB is not picking up the securefile option
Opening and saving a schema trigger will remove trigger options - COMMENT,RENAME
Output spooling slow
AV caused when executing object (on 10g/11g db) using 9i client
running series of sql statements was causing: ORA-01406: fetched column value was truncated
User should not be able to add multiple substitution variables with the same name
Unable to enter euro key “€” in the code editor
I would also like to thank our beta community for working with us to provide valuable feedback on SQL Navigtaor.
Wishing you all a very festive season.
Have a Merry Christmas and Happy New Year and looking forward to working together in the future
SQL Navigator Team