The following are changes in Oracle Database Development Guide for Oracle Database 12c Release 2 (12.2):
Dropping an edition has been enhanced to postpone dropping each editioned object it contains until after the object is no longer inherited by a usable descendent edition.See : Dropping an Edition
The PL/SQL Basic Block Coverage feature helps you insure some quality predictability and consistency by assessing how well your tests actually test your code. See : Using PL/SQL Basic Block Coverage to Maintain Quality
PL/Scope reports on SQL Identifier and Statement metadata for SQL statements, tables, views and sequences appearing in PL/SQL source code.See : Using PL/Scope
DEPRECATE pragma, See: Deprecating Packages, Subprograms, and Types
Sharding is the ability to partition data horizontally across independent databases. Each database in this configuration is called a shard. All the shards together make up a single logical database that is called a sharded database. See : Oracle Database Administrator’s Guide for more information about developing applications in a sharded database.
MAX_TXN_THINK_TIME parameter to configure DRCP. See Configuring DRCP for more information.
Support for sharing proxy sessions in DRCP with other applications. See Sharing Proxy Sessions for more information.
Support for shared connections in both PDB and non-PDB environments using DRCP. See About Database Resident Connection Pool for more information.
Support for receiving FAN event notifications. See About Receiving FAN Event Notifications for more information.
Transaction Guard support for Oracle XA Transactions. See Using Transaction Guard for more information about Transaction Guard.
The following features are deprecated in this release, and may be desupported in a future release:
Oracle SQL Extensions (oracle.sql.*) are deprecated in favor of standard Java classes or oracle.jdbc extension types.
DBMS_DEBUG package is deprecated. Use
DBMS_DEBUG_JDWP package instead.
Some features previously described in this document are desupported in Oracle Database 12c Release 2 (12.2).
Desupport of server-side SQLJ and JPublisher.