Skip Headers

SQL*Plus Release Notes
Release 11.1.0.7

B31209-02
   

SQL*Plus

Release Notes

Release 11.1.0.7

May 2008

B31209-02

 

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 is certified against the operating systems set out in the operating-system specific Oracle Database documentation.

SQL*Plus is certified against Oracle Database 11g Release 1 (11.1) and all supported versions of the Oracle Server.

2 New Features in SQL*Plus

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

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.

2.1 SQL*Plus Error Logging

SQL*Plus has a new SET ERRORLOGGING command to enable error logging of SQL, PL/SQL and SQL*Plus errors.

2.2 BLOB and BFILE Datatypes

SQL*Plus now supports standard querying of tables and objects containing BLOB and BFILE datatypes.

2.3 Escaping Special Characters in File Names

SQL*Plus has a new SET ESCCHAR command to enable specific characters in file names to be escaped.

2.4 FAN Events in a RAC Database

The SQLPLUS command now has a -F argument to enable SQL*Plus to receive FAN events from a RAC database.

3 New Features in Previous Releases

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

3.1 New Features in SQL*Plus 10.2 Production

3.2 New Features in SQL*Plus 10.1 Production

4 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.

4.1 Bugs Fixed in SQL*Plus Release 11.1.0.7

4.2 Bugs Fixed in SQL*Plus Release 11.1

5 Support

For SQL*Plus support, please contact your local Oracle Support Services Center.

6 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.

6.1 Windows Graphical User Interface

The SQL*Plus for Windows graphical user interface (GUI) is desupported in SQL*Plus Release 11.1. In Oracle Database 11g Release 1 (11.1), Oracle recommends using one of the following:

6.2 iSQL*Plus User Interface

The iSQL*Plus user interface is desupported in SQL*Plus Release 11.1. In Oracle Database 11g Release 1 (11.1), Oracle recommends using one of the following:

 

 

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

Copyright © 1996, 2008 Oracle Corporation.

All Rights Reserved.


Oracle
Copyright © 1996, 2008 Oracle Corporation.

All Rights Reserved.