Changes in This Release for SQL*Plus

This preface lists changes in the SQL*Plus User's Guide and Reference

The following are changes in the SQL*Plus User's Guide and Reference for SQL*Plus Release 18c, Version 18.3.

There are no new features for this release.

The following feature is deprecated in this release:

Deprecation of PRODUCT_USER_PROFILE Table

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

The following are changes in the SQL*Plus User's Guide and Reference for SQL*Plus Release 18c, Version 18.1.

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.

See SET FEED[BACK] {6 | n | ON | OFF | ONLY} [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.

See SET ROWLIMIT {n | OFF}
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.

See SET LIN[ESIZE] {80 | n | WINDOW}