Skip Headers

SQL*Plus Release Notes
Release 10.2

B14408-01

SQL*Plus

Release Notes

Release 10.2

June 2005

B14408-01

This document summarizes requirements, differences between SQL*Plus and its documented functionality, new features in this release and support information. It contains the following topics:

1 Certification

SQL*Plus (including iSQL*Plus) is certified against the operating systems set out in the operating-system specific Oracle Database documentation.

SQL*Plus (including iSQL*Plus) is certified against Oracle Database 10g Release 2 (10.2) and all supported versions of the Oracle Server.

2 General Issues and Workarounds

This section describes general issues and their workarounds for SQL*Plus.

2.1 PAUSE Command Requests Input in iSQL*Plus (2995674)

The PAUSE command should print any PAUSE [text], and display the Next Page button. Instead, it displays the Input Required screen, and the [text] as the prompt before the input field.

2.2 iSQL*Plus Does Not Display the Password Expiry Grace Period (3066550)

If a user's password is about to expire, iSQL*Plus does not display the error:

ORA-28002: the password will expire within grace_period days

The user may not realise their password requires changing until the account is locked when the grace period expires.

2.3 iSQL*Plus Does Not Display Multibyte Table Names (4030184)

Some tables with multibyte table names are not displayed in iSQL*Plus. To avoid this issue, do not set LC_ALL when starting iSQL*Plus.

3 New Features in SQL*Plus

SQL*Plus Release 10.2 is a superset of SQL*Plus Release 10.1.

This section describes new features introduced in this release of SQL*Plus. Some features may be affected by the SQLPLUSCOMPATIBILITY setting. See the SET SQLPLUSCOMPATIBILITY Matrix in chapter 12, "SQL*Plus Command Reference" in the SQL*Plus User's Guide and Reference.

3.1 SQL*Plus Supports Lightweight Instant Client

The SQL*Plus Instant Client now supports Lightweight Instant Client and documentation is included in Appendix E of the SQL*Plus User's Guide and Reference.

3.2 AUTOTRACE PLAN Output

Autotrace Plan output now includes additional information and uses the DBMS_XPLAN package format.

3.3 SET SERVEROUTPUT Changes

SET SERVEROUTPUT supports an UNLIMITED size which is the new default.

DBMS_OUTPUT line length limit is increased to 32767 bytes from 255.

You can SET ARRAYSIZE to tune the performance of SET SERVEROUTPUT.

3.4 XQUERY Command

XQUERY is a new SQL*Plus command that enables you to run XQueries against your database in SQL*Plus or iSQL*Plus. There are four new SET XQUERY options associated with this command:

4 New Features in Previous Releases

This section lists new features introduced to SQL*Plus in previous releases.

4.1 New Features in SQL*Plus 10.1 Production

4.2 New Features in SQL*Plus 9.2 Production

5 Bugs Fixed

The following section lists bugs fixed in SQL*Plus. Numbers in parentheses following the problem description refer to bug numbers in the Oracle Bug Database.

5.1 Bugs Fixed in SQL*Plus Release 10.2

6 Support

For SQL*Plus and iSQL*Plus support, please contact your local Oracle Support Services Center. There is also an iSQL*Plus Discussion Forum on the Oracle Technology Network located at http://otn.oracle.com/ which may be helpful.

7 Desupport Notices

This section gives advance notice of the desupport of SQL*Plus commands and interfaces. It is not official notice of desupport dates, nor is it intended to replace the Oracle obsolescence process. This information provides you with advance warning that Oracle Corporation intends to desupport these features/interfaces in upcoming releases.

7.1 COPY Command

COPY supports the datatypes listed for the COPY command in the SQL*Plus User's Guide and Reference, but no new datatypes will be supported. The COPY command may be made obsolete in a future release of SQL*Plus.

7.2 Windows Graphical User Interface

The SQL*Plus for Windows graphical user interface (GUI) will be desupported in a future release of SQL*Plus. The SQL*Plus for Windows command line (DOS) interface will continue to be supported.

 

 

Oracle, JD Edwards, PeopleSoft, and Retek are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Copyright © 1996, 2005 Oracle Corporation.

All Rights Reserved.


Oracle
Copyright © 1996, 2005 Oracle Corporation.

All Rights Reserved.