Changes in This Release for SQL*Plus
This preface lists changes in the SQL*Plus User's Guide and Reference
Changes in SQL*Plus Release 18c, Version 18.3
The following are changes in the SQL*Plus User's Guide and Reference for SQL*Plus Release 18c, Version 18.3.
Deprecated Features
The following feature is deprecated in this release:
-
Deprecation of
PRODUCT_USER_PROFILE
TableStarting in Oracle Database 18c, the SQL*Plus table
PRODUCT_USER_PROFILE
(PUP) table is deprecated.The only use for the
PRODUCT_USER_PROFILE
(PUP) table is to provide a mechanism to control product-level security for SQL*Plus. Starting with Oracle Database 18c, this mechanism is no longer relevant. This SQL*Plus product-level security feature will be unavailable in Oracle Database 19c. Oracle recommends that you protect data by using Oracle Database settings, so that you ensure consistent security across all client applications.
Changes in SQL*Plus Release 18c, Version 18.1
The following are changes in the SQL*Plus User's Guide and Reference for SQL*Plus Release 18c, Version 18.1.
New Features
The following features are new in this release:
-
Display the sql_id for a query
The SET FEEDBACK command has a SQL_ID option to display the sql_id for the currently executed SQL or PL/SQL statements. The sql_id will be assigned to the predefined variable _SQL_ID.
-
Set the number of rows displayed for a query
The SET ROWLIMIT command enables users to set a limit for the number of rows displayed for a query.
-
Dynamically change the output display to fit the screen size
The SET LINESIZE command has a WINDOW option to automatically change the linesize and pagesize for the formatted output according to the width and height of the screen.