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