サポートと今すぐチャット
サポートとのチャット

SQL Navigator for Oracle 8.1 - Release Notes

Release Notes

SQL Navigator® 8.1

Release Notes

October 2025

These release notes provide information about the SQL Navigator® release.

About SQL Navigator 8.1

Thank you for installing SQL Navigator, the Professional Oracle Development Environment of choice for thousands of developers and corporations worldwide.

SQL Navigator provides an integrated environment for developing and testing stored programs, schemas, SQL scripts, and more - all from an easy-to-use graphical user interface. The SQL Navigator family of products is a complete development environment for Oracle server-side development and management. It has been conceived, designed and developed by Oracle developers and DBAs with hands-on experience in the most common problems facing Oracle developers.

View the latest Release Notes containing late-breaking information and known issues about SQL Navigator.

We trust you will find that SQL Navigator significantly improves your productivity, so that your projects are completed faster with a higher level of quality than ever before.

SQL Navigator 8.1 is a major release, with enhanced features and functionality.

Enhancements

Enhancements in 8.1

The following is a list of enhancements implemented in SQL Navigator 8.1.

Table 1: General enhancements

Enhancement Issue ID

SQL Navigator now provides tolerance support of Oracle AI Database 26ai (formerly known as 23ai).

https://www.oracle.com/news/announcement/ai-world-database-26ai-powers-the-ai-for-data-revolution-2025-10-14/

https://blogs.oracle.com/database/post/oracle-announces-oracle-ai-database-26ai

SQLNAV-2491
SQL Navigator now supports the latest patches of Windows 11, Windows Server 2022, and Windows Server 2025. SQLNAV-2492
SQL Navigator now provides enhanced Team Coding support for Azure DevOps Services (TFVC), Microsoft Azure DevOps Server - formerly known as Team Foundation Server (TFS) - covering versions 2019, 2020, and 2022. SQLNAV-2493

Enhancements in 8.0

The following is a list of enhancements implemented in SQL Navigator 8.0.

Table 2: General enhancements

Enhancement Issue ID
SQL Navigator now supports Microsoft Server 2022 and Oracle 21c. SQLNAV-2368
SQL Navigator now supports noneditable keywords for Triggers/ Functions/Packages/Package Body. SQLNAV-2366
We have upgraded to the latest edition of QP5 in order to access the most recent formatting and parsing syntax capabilities. SQLNAV-2355
All the third party tools have been upgraded to their most latest versions. SQLNAV-2354
SQL Navigator now supports Windows 11. SQLNAV-2343

Deprecated Databases and Operating Systems

  • Windows 8.1

  • Windows Server 2012 R2

  • Oracle Client or Instant Client 10.2.0.5

  • Oracle Client or Instant Client 11.2.0.1/11.2.0.3

  • Oracle 10g Release 2

  • Oracle 11g Release 1 and 2

Resolved Issues

Issues resolved in SQL Navigator 8.1

Table 3: General resolved issues

Resolved Issue Issue ID
Users experience refresh issues in Team Coding when multiple database users attempt to simultaneously check out and check in the same package. SQLNAV-2519
When comparing contents in the Team Coding Manager Revision History using SQL Navigator on Azure DevOps 2022, SQL Navigator displays the Error loading C:\users\DEWOLFFM\Appdata\local\temp\Nav7OESG error. SQLNAV-2487
SQL Navigator is generating incorrect DDL statements for identity columns for primary key. SQLNAV-2485
Code Assist (IntelliSense) does not fully support all DML statements. Issues occur particularly with nested DML statement aliases, especially in UPDATE queries, subqueries, and when using grouping functions such as SUM, MAX, and others. SQLNAV-2483
Users are unable to export query result table data to the latest Excel file format (.xlsx). SQLNAV-2480
TFS Team Coding restricts users from entering more than 255 characters in the comment box during object check-in and check-out. When the character limit is exceeded, SQL Navigator displays the warning message: Maximum 255 characters allowed. SQLNAV-2478
When users select specific schema options (rather than Select All) while checking in objects through TFS, SQL Navigator checks in all items regardless of the selections made in the dialog. SQLNAV-2475
Users are unable to manually remove the time component from a date field in the editor. The time value can only be cleared through the GUI menu, not by typing directly into the field. SQLNAV-2468
When users check out the package specification from SVN, both the package specification and body are locked, whereas only the specification is expected to be locked. The same behavior occurs during check-in when unlocking the package specification. SQLNAV-2467
In tables with multiple triggers, after editing and saving one trigger, opening another from the DB Navigator may display the previously edited trigger instead of the selected one. SQLNAV-2466
When users execute a SELECT query with an ORDER BY ASC clause on a date column and then switch to another tab, SQL Navigator does not retain the ORDER BY statement. SQLNAV-2465
Users are unable to update records through the grid interface (F2) when working with Oracle tables that use double quotes in field names. If the query involves tables with double-quoted fields, record updates via the grid result UI do not function as expected. SQLNAV-2456
After using the Find and Replace option, users are unable to manually replace text in the editor. SQLNAV-2454
Objects or tables updated in the database are not reflecting in the VCS repository, even after creating a new revision. SQLNAV-2450

The following options are not enabled in SQL Navigator under the Team Coding menu:

  • Add file

  • Check Out

  • Check In

  • Undo Checkout

SQLNAV-2448
SQL Navigator generates a query with an incorrect format for the Get Metadata script in the Editor tab. SQLNAV-2443
When using SQL Navigator to generate stubs while executing a function from a package, the output generated from Oracle 12c differs from that generated from Oracle 19c. SQLNAV-2314

Issues resolved in SQL Navigator 8.0

Table 4: General resolved issues

Resolved Issue Issue ID
Users are experiencing slowness when when loading large size PL/SQL packages. This issue has been observed following an upgrade from SQL Navigator version 5.5 to 7.6. SQLNAV-2394
The Zlib library has been upgraded from 1.2.7 to 1.2.13 in order to address issues related to the WhiteSource scan. SQLNAV-2356
SQL Navigator is encountering slow loading times across various screens and functions, particularly when interacting with triggers. SQLNAV-2349
Users are unable to extract a Data Definition Language (DDL) using the 'Use EDITIONABLE OR NONEDITIONABLE' parameter through SQL Navigator. SQLNAV-2341
SQL Navigator encounters slow loading times when attempting to open large objects containing more than 10,000 lines from a database. This issue has been observed across versions 7.6, 7.4, and 7.1. SQLNAV-2337
SQL Navigator displays the 'ORA-9000: invalid SQL Statement' error when a user tries to execute a query for creating a noneditable procedure. SQLNAV-2334
Users are unable to compile extracted metadata using the Get Metadata function when the 'EDITIONABLE' clause is present in the Data Definition Language (DDL) definition. SQLNAV-2317
SQL Navigator displays an error when users attempt to format code containing case statements in versions 7.5 and 7.4. SQLNAV-2254
The update checker in SQL Navigator 7.4 displays inaccurate information when accessed through the Help > Check for Updates section. SQLNAV-2224
セルフ・サービス・ツール
ナレッジベース
通知および警告
製品別サポート
ソフトウェアのダウンロード
技術文書
ユーザーフォーラム
ビデオチュートリアル
RSSフィード
お問い合わせ
ライセンスアシスタンス の取得
Technical Support
すべて表示
関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択