Sql*Plus User’s Guide and Reference

Conventions
The following text conventions are used in this document:
Convention
Meaning
boldface
Boldface type indicates graphical user interface elements associated 
with an action, or terms defined in text or the glossary.
italic
Italic type indicates book titles, emphasis, or placeholder variables for 
which you supply particular values.

---

xv
monospace
Monospace type indicates commands within a paragraph, URLs, code 
in examples, text that appears on the screen, or text that you enter.
Convention
Meaning

---

xvi

---

xvii
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 12.1
The following are changes in the SQL*Plus User's Guide and Reference for SQL*Plus 
Release 12.1.
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
 on page 5-25.
■
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
 on page 3-10
■
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]
 on page 12-100
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
 on page 12-180
See 
SHOW
 on page 12-168
■
New Administrative Privileges

---

xviii
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
 on page 3-6
See 
CONNECT
 on page 12-39
See Oracle Database Administrator's Guide