Changes in This Release for Oracle Database SQL*Plus User's Guide and Reference
This preface contains the changes in this book for Oracle Database 23ai.
New Features
This section lists new features introduced in SQL*Plus releases.
SQL*Plus Release 23ai
This section describes new features introduced in SQL*Plus in 23ai.
-
A new command,
CONFIG
, generates the config store JSON file from thetnsnames.ora
file. -
A new command,
ARGUMENT
, customizes the input prompt and sets default values when parameters are not passed to the script. -
A new command,
PING
, pings the database or database network listener to check availability. - Display error details
- A new command,
OERR
, allows users to see the detailed cause and action text for Oracle errors. - A new command,
SET ERRORDETAILS
, displays the Oracle Error Help URL along with the cause and action details when any SQL, PL/SQL, or SQL*Plus statement fails during execution. - The
HELP
command is enhanced to display error details, such as Cause, Action, and Parameters, for the provided error code.
- A new command,
-
The
DESCRIBE
command is enhanced to display annotation information for columns that have associated annotations available. - The
SHOW CONNECTION
command lists the Oracle Net Service Names present in thetnsnames.ora
file and resolves the given net service name to the connection string. - Support for the
SQL BOOLEAN
data type - Support for a new data type,
VECTOR
, in SQL*Plus.
SQL*Plus Release 21c
This section describes new features introduced in SQL*Plus in 21c.
-
The
HISTORY
command syntax has been enhanced. If N is omitted in the command, thenRUN
,EDIT
orDELETE
is executed on the most recent entry in the history list. -
SET JSONPRINT
is a new command that enables you to format JSON data.
Deprecated Features
This section lists the deprecated features in Oracle Database release 23ai.
Deprecation of FIPS Parameters
Starting with Oracle Database 23ai, several parameters associated withFIPS_140
are deprecated. FIPS_140
in FIPS.ORA
can be used to
enable FIPS
for all features starting with Oracle Database 23ai. The
following FIPS parameters are deprecated:
- SQLNET.ORA:
FIPS_140
to enable FIPS for native network encryption - FIPS.ORA:
SSLFIPS_140
to enable FIPS for TLS - Initialization parameter:
DBFIPS_140
to enable FIPS for TDE andDBMS_CRYPTO
Deprecation of Enterprise User Security (EUS)
Enterprise User Security (EUS) is deprecated with Oracle Database 23ai.Oracle recommends that you migrate to using Centrally Managed Users (CMU). This feature enables you to directly connect with Microsoft Active Directory without an intervening directory service for enterprise user authentication and authorization to the database. If your Oracle Database is in the cloud, you can also choose to move to one of the newer integrations with a cloud identity provider.