Changes in This Release for SQL*Plus

New Features

The following features are new in this release:

• Support for Iterative Results (Implicit Results)

  SQL*Plus can now iteratively return results from a PL/SQL Statement without using a local ref cursor.

  See Fetching Iterative Results from a SELECT inside a PL/SQL Block.

• Last Login Time

  SQL*Plus now displays the time you last logged on by default. This security feature can be turned off with a SQLPLUS command option -nologintime.

  See No Login Time Option

• Displaying Invisible Columns

  SQL*Plus has a new SET command, SET COLINVI[SIBLE] to allow invisible column information to be viewed with the SQL*Plus DESCRIBE command. This feature is intended to assist in application development, and only expose new content when ready.

  See SET COLINVI[SIBLE] [ON | OFF]

  See Oracle Database SQL Language Reference

• Pluggable Database Support

  New STARTUP command options now support pluggable databases.

  There are three new SHOW command options to display information about pluggable databases: SHOW CON_ID, SHOW CON_NAME and SHOW PDBS.

  See STARTUP

  See SHOW

• New Administrative Privileges

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

  See SQLPLUS Program Syntax

  See CONNECT

  See Oracle Database Administrator's Guide

Desupported Features

Some features previously described in this document are desupported in Oracle Database 12c Release 1 (12.1). See Oracle Database Upgrade Guide for a list of desupported features.