Quest® Knowledge Xpert for PLSQL

Version 10.1

Release Notes

September 2008

Welcome to Knowledge Xpert for PLSQL

Knowledge Xpert for PL/SQL is a comprehensive Windows-based technical resource that covers the entire lifecycle of PL/SQL programming - from development to administration. Thousands of topics provide the background information, best practices and examples programmers need to write optimized, bulletproof code.

Back to Top

New in This Release

New User Interface Features in Knowledge Xpert for PLSQL 10.1

• Check for Updates - This feature on the Knowledge Xpert Home page allows you to check for and download new Knowledge Xpert content updates. This enables you to keep your content up-to-date between full releases of the product.
• Enhanced Search - You can now search for a phrase in quotes (for example: enter "database tables" to find all topics that contain this exact phrase).
• Favorites - In addition to adding favorites, version 10.1 enhancements enable you to remove, rename, and organize favorites.
• Comments - This feature reintroduces the ability to add notes and attachments to topics. You can add, edit, or delete comments and share comments with your colleagues through a common directory. Version 10.1 provides an option, at first launch of the product, to migrate any attachments or topic notes from previous versions into comments.
• History - Instead of having the same topic title display repeatedly in the History list, it displays only once with the most recent access date.
• Hot Keys - Additional hot keys provide shortcuts that open Knowledge Xpert menus, print pages, and move quickly through the user interface without the need to use a mouse.
   

New Content in Knowledge Xpert for PLSQL 10.1

The following sections have been added or updated in Knowledge Xpert for PL/SQL 10.1:

Coding Best Practices - Highlights for this section include:

• New - SQL Best Practices: Tips and Tricks
• New - Oracle and ANSI SQL Joins
• New - Data Model Red Flags
• Updated - Writing Efficient SQL

Back to Top

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of Knowledge Xpert for PLSQL.

Back to Top

Known Issues

The following is a list of issues known to exist at the time of Knowledge Xpert for PLSQL release.

Back to Top

Third Party Known Issues

There are no third party issues known to exist at the time of Knowledge Xpert for PLSQL release.

Back to Top

Upgrade and Compatibility

Knowledge Xpert 10.1 knowledge bases are available for the following:

• Oracle Administration
• Oracle PL/SQL
• DB2
• MySQL
• SQL Server

Note: You do not need to uninstall previous versions of Knowledge Xpert before you install 10.1.

If you want to upgrade Knowledge Xpert for PLSQL, install to the same directory where it currently resides. This requires you to also upgrade any other Knowledge Xpert knowledge bases installed in that directory. The default directory is C:\Program Files\Quest Software\Knowledge Xpert.
 

If you want to install this version of Knowledge Xpert but do not want to overwrite the existing version or interfere with other Knowledge Xpert knowledge bases, then install this version to a directory other than the one where you installed the previous version.

See Getting Started for installation instructions.

Back to Top

System Requirements

Before installing Knowledge Xpert for PL/SQL, ensure your system meets the following minimum hardware and software requirements:

Back to Top

Global Operations

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.
 

This release supports any single-byte character set. Double-byte or multi-byte character sets are not supported. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe.

Back to Top

Getting Started

Contents of the Release Package

You often have an opportunity to install Knowledge Xpert when you install other Quest products. It is also available as a standalone product from SupportLink at http://support.quest.com/. The install includes the following:

• Knowledge Xpert executable and knowledge base files
• Product Documentation, including:
  • Help
  • Release Notes

Installation Instructions

To install Knowledge Xpert

1. Download the executables for the Knowledge Xpert products you want to install on your system from SupportLink at http://support.quest.com/.
2. Click the executable (KXDB2.exe, KXSQLServer.exe, KXMySQL.exe, KXORADM.exe, KXPLSQL.exe) to install each Knowledge Xpert product separately. The installer prompts for the directory where you want to install the product.
3. From the installation folder (default folder is C:\Program Files\Quest Software\Knowledge Xpert), click KXpert.exe or click the Knowledge Xpert icon on your desktop to launch the product. The opening window lists the installed knowledge bases.

Back to Top

For More Information

Contacting Quest Software:

Refer to our web site for regional and international office information.

Contacting Quest Support:

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract.
Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com/.

From SupportLink, you can do the following:

• Quickly find thousands of solutions (Knowledgebase articles/documents).
• Download patches and upgrades.
• Seek help from a Support engineer.
• Log and update your case, and check its status.

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, and policy and procedures.
The guide is available at: http://support.quest.com/pdfs/Global%20Support%20Guide.pdf.

Back to Top

© 2008 Quest Software, Inc.

ALL RIGHTS RESERVED.

This document contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.

If you have any questions regarding your potential use of this material, contact:

Refer to our web site for regional and international office information.

Trademarks

Quest, Quest Software, the Quest Software logo, Benchmark Factory, Quest Central, Spotlight, SQL Navigator, SQLab, SQL Watch, StealthCollect, Toad, T.O.A.D., Toad World, are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

Disclaimer

The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.

Back to Top