SQL
Navigator® for Oracle
Version 6.0.0 Release Notes
Release Notes
12 September 2008
Contents
Welcome
to SQL Navigator for Oracle 6.0.0
New in
this Release
Getting
Started
Resolved Issues and Enhancements
Third
Party Team Coding Support
Support
of the Euro Character
Support
of Oracle features
Known Issues
Third
Party Provider Known Issues
System Requirements
Global
Operations
For More Information
Thank
you for installing SQL Navigator® 6.0.0, 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 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.
Back
to Top
Contents
of the Release Package
The SQL Navigator® for Oracle release package contains
the following products:
- SQL Navigator® for Oracle 6.0.0
- Knowledge
Xpert for PL/SQL 10.1.0
- Quest SQL Tuning for Oracle 7.4.0
- Quest Toad Data Modeler
3.2.5
- SQL
Monitor 2.4.3
- Product
Documentation, including:
- Quick Start Guide
- User
Guide
- Online Help, etc
A "ready to print" copy of the Users
Guide, Users Guide Supplement and
Getting Started manuals are provided in Adobe Acrobat format (also
available from Start Menu). If you do not have a copy of Adobe Acrobat
installed on your system, please visit http://www.adobe.com.
Printed
manuals are available for purchase from our e-Store at
http://www.quest.com
(navigate to the SQL Navigator® page).
On
the installation CD we have also provided several "Tips &
Tricks"
articles to help you get the most from SQL Navigator®. To view
additional Tips as they are added, please regularly visit our SQL
Navigator Inside Community.
Installation
Instructions
Refer to SQLNavigator_InstallationNotes.htm
for installation instructions.
Back
to Top
New Features in SQL Navigator® 6.0.0
-
New Code Editor:
SQL Editor and the
Stored Program Editor are
merged into one single Code Editor. Hence,
Code Editor also provides these convenient
features to deal with stored programs.
- New Execution console and Debugger: In previous versions, you can
ONLY have one debugger session for the whole application. In version 6.0,
you can have one debugger session for each open Oracle DB connection. SQL
Navigator® allows you to debug many objects at a time.
- General workflow enhancements and improvements.
- Unicode Data Support: The new data grid in the Code Editor can
display, edit data in many languages.
- Full LDAP with AD support.
Updates
to SQL Navigator® 5.5
- CodeXpert - The
CodeXpert utility has been improved to provide multi file/objects
support.
- Centralized database alias
lookup -
Support for centralized database alias lookup via LDAP (Oracle Internet
Directory and Microsoft Active Directory) has been added.
- Knowledge
XPert for PL/SQL - Knowledge XPert for PL/SQL has
been updated to the latest version 9.0.
New Features in SQL Navigator® 5.5
- Transparent Data Encryption (TDE) -
As part of
SQL Navigator’s support for TDE (as introduced in Oracle 10g
Release 2), the following features are available:
- Selecting
columns to be encrypted and decrypted in the Table VOE, as well as
specifying the encryption algorithm to be used
- Viewing
encryption-related table column properties in the DB Navigator Tree
- Performing
multiple table encryption rekeying from the DB Navigator Tree and Find
Object window
- Opening
and closing the Oracle wallet, as well as setting the encryption key
from the new “Wallet Operations” menu item under
the
Session menu and on the toolbar
- Extracting the ddl
of tables
with encryption columns, with a new preference (In Extract DDL |
Table/View Specific) to control this behaviour, “Include
encryption clause”.
- New
Job Scheduler -
In previous versions, SQL Navigator® provided a tool
for creating
and managing jobs – Job Manager. It was based on using the
DBMS_JOB package, which is now de-supported by Oracle and will likely
be removed in a future version. Starting from the version 10g, Oracle
includes a new system package for similar purposes, DBMS_SCHEDULER, and
new related system views. It is much more advanced and introduces a
number of new concepts: programs, schedules, job classes, etc. It was
decided to completely rewrite the Job Manager in v5.5.2 to take
advantage of the new features provided by the Job Scheduler package in
Oracle and ensure that the module will not stop working in future
versions of Oracle.
- New
Project Manager -
Project Manager (formerly Workspace Manager) allow you to only display
windows that are linked to the current project. For example, say you
are working on some changes to the CRM system your company is
developing when a change request comes through for another project that
you are responsible for. The changes to SQL Navigator®
will allow you
switch to another Project within the Project Manager, and have SQL
Navigator® display only the windows that you need for the
Project
you
are working on. The Project Manager also gives you the ability to
restore your entire work area (upon start-up) including all opened
sessions, database objects and SQL Editors.
- New
Profile Manager - The
Profile Manager lets you backup and restore your SQL Navigator®
user
preferences for each version. This function can be accessed via the
Start menu.
- Side by
side support - Side by side support allows multiple versions
of SQL Navigator® to be run on the same machine.
- Community
link - A
link is available from within SQL Navigator® to link to the new
Quest
community for obtaining or providing feedback to users and Quest
support and developers.
- Quest's
Toad™ Data Modeler
- A freeware version of Quest's Toad Data Modeler tool is now
bundled and installed with SQL Navigator®. This is a
professional
database modelling tool, designed to visually create and maintain
Entity Relationship Diagrams (ERD) and Data Flow Diagrams (DFD). It
uses well-arranged ER Diagrams through which complex SQL scripts are
generated automatically. When creating ER Diagrams, the program
considers individual database options such as referential integrity,
constraints, domains, triggers etc. All the text objects and
also
other parts of ER Diagrams can be reverse engineered from already
existing database structures. Toad™ Data Modeler is
a highly
customized software that enables database designers to generate very
detailed RTF and HTML reports also. The freeware version
doesn’t include all features and allows you to save a model
with less than 25 entities.
Back to Top
The following is a list of
issues addressed and enhancements implemented in this release of SQL
Navigator® for Oracle:
|
Area
| Resolved
Issue
|
| General |
| Knowledge Xpert is now part of the Standard
Edition |
| Many Extract DDL issues have been
addressed in this release. |
|
Cannot open
Clipboard error message and "Invalid Pointer Operation" |
|
|
Release 5.5: Server
output is not displaying dbms_output messages. |
|
|
Add preference not
to display the SQL Navigator splash screen |
|
| Floating dockable window shifts when display. |
| Connectivity | Support connection to 11g DB. |
| Add
LDAP support for Active Directory |
| Code Editor |
Split windows feature has been added. |
Many issues and
enhancements reported in previous releases with the SQL Editor and the
Stored Program have been addressed with the introduction of the new Code
Editor.
|
| Installation | Using the Quest
Installer which support silent, push and side by side installations. |
Back to Top
Third Party Team
Coding Support
SQL
Navigator's Team Coding module directly
supports the following products:
Microsoft Visual SourceSafe 5.0/6.0 SP6d (Windows
NT 4, 2000, XP)
Serena PVCS VM 6.6/6.7/6.8/7.5/8.0.2 (Windows NT
4, 2000, XP)
Serena PVCS VM 5.2/5.3/6.0 (Windows NT 4, 2000, XP)
Team
Coding will also operate with certain products providing Microsoft's
SCC API. Implementation of this interface varies between products
however. The products tested with, and supported by, SQL
Navigator®
include:
Rational ClearCase 4.1/2002 (Windows NT 4, 2000,
XP)
Borland StarTeam 4.2/5.1/5.4/6.0/2005 (Windows NT
4, 2000, XP)
CVS Server 1.x/2.x* (Up to 2.5x for CVSNT)
- Microsoft Team Foundation Server (Windows Server 2003)
Each
third party product may require a custom installation to install the
SCC interface. Please refer to the topics "Installing Team Coding
options" and "Installing third-party version control products" in the
Online Help, as well as documentation supplied by the vendor. There may
also be a SCC interface installer available on the vendor's
website.
Please
note that a Third Party Version Control product is not a requirement
for Team Coding - all functionality except for revision history
(Version Control Browser) is always available if Team Coding is enabled.
Using
User Mapping with Triggers and Views
If
you are using User Mapping (please refer to Online Help for details),
Team Coding must modify the DDL in order to create the object in the
User's schema. This primarily involves replacing any references to the
original schema. For example, consider the DDL for the following
Views:
create or replace VIEW scott.vemp1 as select * from scott.emp;
create or replace VIEW scott.vemp2 as select * from emp;
The
DDL which will be executed during import, Get Latest Revision, etc.
will be modified to:
create or replace VIEW otheruser.vemp1 as select * from otheruser.emp;
create or replace VIEW otheruser.vemp2 as select * from emp;
In
both cases, the referenced table must exist in the other user's schema,
or the view will be invalid. In the case of triggers, it will not be
created by Oracle. If you require that the triggers and views refer to
the tables in the original schema, we recommend creating synonyms for
them in the other users schema.
Note:
Schema replacement
affects all objects maintained by Team Coding, so it is possible that
explicit schema references in any stored program may result in invalid
objects when using User Mapping
Accessing
Triggers from a different user
When
using Team Coding to manipulate triggers as a user other than the owner
of the objects, certain steps must be followed prior to performing
check in/out operations. Failure to follow these steps will lead to
errors such as "ORA-00942: table or view does not exist".
- The
steps to avoid this problem are as follows. They should be performed
before creating any revisions in your Version Control provider's
repository; however, they can be performed at any time:
- When
connected as a user with Team Coding Administration privileges,
ensure that the Team Coding connection setting "Use Trigger Description
for DDL" is enabled.
- When connected as any user
with access to triggers, use the Find
Objects Tool or the Details Panel of the DB Navigator to select all
triggers mapped to a Team Coding group
- From the
Object menu/toolbar or pop-up menu, choose Extract DDL.
- In
Extract DDL Preferences, ensure that "Prefix with Schema Name" is
enabled, and that "Show Trigger Snapshot" is not enabled, then click OK
- Execute
the generated script.
- From the Code Control
Groups window, perform an Export of your triggers
to your Version Control provider project. Ensure that the "Create a
revision only if the object has changed" option is enabled.
Following
these steps will ensure that the original schema name is stored in the
DESCRIPTION column of the ALL_TRIGGERS view, and that Team Coding will
use the original DDL text rather than generating the DDL from the other
columns of this view. Subsequent use of Team Coding operations which
replace the trigger will perform correctly. Functionality affected
includes Get Latest Version, Check In (with the preference
"Update database after Check-In" enabled) Import and Export (with the
preference "Update database after Check-In" enabled).
Note:
if the trigger owner using the Trigger Editor subsequently modifies a
trigger, the DDL generated does not include the schema, which will
re-introduce this issue. It is recommended that for this release you do
not mix trigger modification between trigger owner and other users if
Team Coding controls the trigger.
Finally,
the CREATE ANY
TRIGGER privilege is required for User mapping or when modifying or
importing a Trigger as a different user. The SELECT privilege may also
need to be granted to users creating views in different schemas for the
table referred to by the view.
Back to Top
Support of the Euro Character
SQL
Navigator® 6.0.0 provides full support of the Euro character
(€).
The default fonts permit the Euro character to be displayed or entered
in all areas of the SQL Navigator® user interface. Support of
the Euro
can however be affected by user configuration, such as choosing a font
set which does not include the symbol. It is also dependant on
operating system, Oracle client and Oracle server configuration.
These
issues are well documented by both Oracle and Microsoft, and Quest
Software can provide details upon request. Basic requirements are
detailed below:
- The
original release of Microsoft
Windows NT 4 did not include Euro support. Patches are available from
Microsoft to provide this support (NT SP4 or greater).
- The
following fonts supplied with all versions of Microsoft Windows do not
include the Euro symbol:
- Courier
- Fixedsys
- MS
Sans Serif
- MS Serif
- Small Fonts
- System
- Terminal
- If
your keyboard does not provide the Euro symbol, it may be entered by
using the numeric keypad and the ALT+0128 key combination
- Both
Oracle Server and Client must be configured to NLS_LANG character sets
which include the Euro symbol. Refer to Oracle Metalink, document ID
68790.1
To test Euro support
in the SQL Editor (spool window and results grid), execute the
following statement:
select chr(128) from dual;
Back
to Top
Oracle
feature |
Support |
Tables |
·
Standard relational tables |
YES |
·
Partitioned (range, hash and composite) Tables + |
YES |
·
Partitioned (list) Tables +++ |
YES |
·
Object tables + |
YES |
·
Queue tables + (including
schedules) |
NO |
·
Index-organized tables + |
YES |
·
Temporary tables + |
YES |
·
External tables +++ |
YES |
Views |
·
Standard views |
YES |
·
Inline views |
YES |
·
Object views + |
YES |
·
Join views (including updateable) + |
YES |
·
Check option on views + |
YES |
·
Read only option on views + |
YES |
·
Polymorphic Views +++ |
NO |
·
Views Hierarchies +++ |
NO |
·
Views with Constraints +++ |
NO |
Constraints
(definition, clauses and storage) |
·
Primary keys |
YES |
·
Unique keys |
YES |
·
Foreign keys(including external FKs, views
FKs+++) |
YES |
Procedures |
YES |
·
Java/C Methods Calls + |
YES |
·
Invokers Right + |
YES |
Functions |
YES |
·
Java/C Methods Calls + |
YES |
·
Invokers Right + |
YES |
Packages |
YES |
·
Header |
YES |
·
Body |
YES |
·
Invokers Right + |
YES |
Indexes |
·
Standard |
YES |
·
Bitmap |
YES |
·
Bitmap Join Index +++ |
NO |
·
Descending ++ |
YES |
·
Reverse key + |
YES |
·
Partitioned + |
YES |
·
Global + |
YES |
·
Local + |
YES |
·
Non-prefixed + |
YES |
·
Pre-fixed + |
YES |
·
Function-based ++ |
YES |
Materialized
views ++ |
YES |
·
Index-Organized Materialized Views +++ |
YES |
·
Indexes on Materialized Views +++ |
YES |
·
XML, LOB, nested
table, varray
type columns +++ |
YES |
Materialized
view Logs ++ |
NO |
Snapshots
(Oracle 7.3.4 up to
Oracle 8.0.x Only) |
NO |
·
Simple and complex |
NO |
·
Registered |
NO |
·
Read-only and updateable |
NO |
·
Complete, ROWID and primary key fast refreshes |
NO |
Snapshot
logs (Oracle 7.3.4 up to
Oracle 8.0.x only) |
NO |
·
Record with Object ID or Sequence +++ |
NO |
Refresh
groups ++ |
NO |
Datatypes |
Built-in
Datatypes |
YES |
Character |
YES |
CHAR |
YES |
NCHAR+ |
YES |
VARCHAR2 |
YES |
NVARCHAR2+ |
YES |
LONG |
YES |
CLOB+ |
YES |
NCLOB+ |
YES |
Number |
YES |
Date
types |
DATE |
YES |
TIMESTAMP
+++ |
YES |
TIMESTAMP
WITH TIME ZONE +++ |
YES |
TIMESTAMP
WITH LOCAL
TIME ZONE+++ |
YES |
INTERVAL
YEAR TO MONTH +++ |
YES |
INTERVAL
DAY TO SECOND+++ |
YES |
Binary
data types |
RAW |
YES |
LONG
RAW |
YES |
BLOB |
YES |
BFILE
+ |
YES |
Binary_Float ++++ |
YES |
Binary_Double ++++ |
YES |
Ids |
ROWID |
YES |
UROWID
+ |
YES |
ANSI DB2,
SQL/DS datatypes |
YES |
User
defined data types+ |
Collection
Types + |
YES |
Object
Types + |
YES |
Oracle
Supplied types+ |
"Any"
Types +++ |
NO |
XML
Types +++ |
YES |
Spatial
Types + |
NO |
Media
Types ++ |
NO |
Context
Text Types + |
NO |
Operators |
NO |
·
User
defined ++ |
NO |
·
Ancillary ++ |
NO |
Triggers |
·
Standard |
YES |
·
Instead-of + |
YES |
·
Database-event + |
YES |
·
Nested-table view triggers ++ |
YES |
Clusters |
YES |
·
Non-hash |
YES |
·
Hash |
YES |
·
Row level dependency tracking +++ |
NO |
Collections |
YES |
·
Nested tables + |
YES |
·
VARRAYs + |
YES |
Java
support |
·
JDBC code + |
NO |
·
SQLJ code + |
NO |