1. User's Guide and Reference
  2. Changes in This Release for SQL*Plus

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

    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}

Changes in SQL*Plus Release 12.2.0.1.0

The following are changes in the SQL*Plus User's Guide and Reference for SQL*Plus release 12.2.0.1.0

New Features

The following features are new in this release:

  • Support for command history

    SQL*Plus now supports command history. The command history feature enables users to run, edit, or delete previously used SQL*Plus, SQL, or PL/SQL commands from the history list in the current session.

    See HISTORY

    See SET HIST[ORY] {ON | OFF | n}

    See SHOW HISTORY

  • Support for long identifiers

    SQL*Plus now supports object lengths of 128 bytes. In previous releases, the object length limit was 30 bytes.

  • Commands to improve performance

    SQL*Plus has new commands that improve performance in certain cases. The new commands enable users to control row and LOB prefetching, as well as statement caching.

    See SET LOBPREFETCH {0 | n}

    See SET ROWPREFETCH {1 | n}

    See SET STATEMENTC[ACHE] {0 | n}

  • New Administrative Privilege

    The SQLPLUS and CONNECT commands now support the new user privilege SYSRAC as well as the existing SYSBACKUP |SYSDG | SYSKM |SYSASM |SYSDBA |SYSOPER privileges.

    See SQLPLUS Program Syntax

    See CONNECT

    See Administrative User Accounts

  • Support for input binding by using the VARIABLE command. The VARIABLE command now supports input binding which can be used in SQL and PL/SQL statements.

  • Support for CSV format data. The SET MARKUP command now has a CSV option to output data in CSV format.

  • The SET FEEDBACK command has an ONLY option to display the number of rows selected. No data is displayed.

  • SQL*Plus command-line option –AC sets the Application Continuity flag for the session. For more information about Application Continuity, see the Oracle Call Interface Programmer's Guide.

  • SQL*Plus command-line option –F[ast] changes the values of the following default settings:

    • ARRAYSIZE = 100

    • LOBPREFETCH = 16384

    • PAGESIZE = 50000

    • ROWPREFETCH = 2

    • STATEMENTCACHE = 20

    These settings improve general performance.

Desupported Features

See Oracle Database Upgrade Guide for a list of desupported features.