Name

SET SQLPLUSCOMPATIBILITY

Synopsis

The SQLPLUSCOMPATIBILITY setting requests the behavior of a specific version of SQL*Plus. Its use is much like that of the COMPATIBILITY setting of a database instance.

Syntax

SET SQLPLUSCOMPAT[IBILITY] version.release[.update]

Parameters

SET SQLPLUSCOMPAT[IBILITY]

Is the command, which may be abbreviated SET SQLPLUSCOMPAT.

version

Is a version number, such as the 8 in 8.1.7.

release

Is a release number, such as the 1 in 8.1.7.

update

Is an update number, such as the 7 in 8.1.7.

Table A-2 describes those aspects of SQL*Plus behavior controlled by the SQLPLUSCOMPATIBILITY setting. The threshold in the table represents the point at which the described behavior became available. The earliest acceptable value for SQLPLUSCOMPATIBILITY is 7.3.4.

Table A-2. SQLPLUSCOMPATIBILITY behaviors

Threshold

Behavior

10.1

SHOW ERRORS sorts PL/SQL error messages using some new data dictionary columns from user_errors that are available only beginning in Oracle Database 10g.

10.1

The CREATE, REPLACE, and SAVE options become available for the SPOOL command.

10.1

The Windows versions of SQL*Plus allows filenames enclosed in quotes to contain whitespace characters.

10.1

glogin.sql and login.sql are executed when SQL*Plus is first run and after every successful CONNECT command.

10.1

SQL*Plus stops prefacing lines from /* comments with "DOC>".

9.2

A column defined as FOLD_AFTER may be displayed at the beginning of a new line if that's necessary because of the column's width.

9.0

A slash preceded ...

Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.