New In Oracle Database Version 18cR1 and R3
Version 12.2.0.1

New PL/SQL
Before/After Set Container System Event Trigger System Event Trigger 13-May-2017
Pragma Coverage Pragma Coverage 04-Apr-2017
Pragma Deprecate Pragma Deprecate 04-Apr-2017
 
New or Modified Functions, Operators, Procedures, and Types
APPROX_COUNT_DISTINCT_AGG Function Numeric Function TBD
APPROX_COUNT_DISTINCT_DETAIL Function Numeric Function TBD
APPROX_MEDIAN Function Numeric Function TBD
APPROX_PERCENTILE Function Numeric Function TBD
APPROX_PERCENTILE_AGG Function Numeric Function TBD
APPROX_PERCENTILE_DETAIL Function Numeric Function TBD
COLLATION Function Miscellaneous Function TBD
FEATURE_COMPARE Function Miscellaneous Function TBD
JSON_DATAGUIDE Function JSON Functionality 20-Oct-2017
NLS_COLLATION_ID Function Miscellaneous Function TBD
NLS_COLLATION_NAME Function Miscellaneous Function TBD
ORA_DM_PARTITION_NAME Function Miscellaneous Function TBD
ORA_NAME_LIST_T has been redefined using new 12cR2 syntax DBMS_STANDARD 26-Jun-2017
PERMIT_92_WRAP_FORMAT Compiler Directive Compilation Parameters 03-Mar-2017
SYS_CONTEXT has a new SESSION_DEFAULT_COLLATION predefined parameter SYS_CONTEXT 18-Jan-2017
TO_APPROX_COUNT_DISTINCT_AGG Function Numeric Function TBD
TO_APPROX_PERCENTILE Function Numeric Function TBD
VALIDATE_CONVERSION Function Miscellaneous Functions 03-Mar-2017
 
Object Rename
DBMS_LOGMNR_SESSION (in 12.1) renamed to DBMS_LOGMNR_SESSION_INT DBMS_LOGMNR_SESSION_INT 24-May-2017
 
XML and XML
JSON Data Guides JSON Data Guides TBD
 
New Built-in Packages
CDBVIEW_INTERNAL with 1 procedure CDBVIEW_INTERNAL 24-May-2017
DBMS_AQADM_VAR with 3 functions DBMS_AQADM_VAR 19-Mar-2017
DBMS_AUDIT_UTIL with 4 functions DBMS_AUDIT_UTIL 18-Mar-2017
DBMS_CRYPTO_INTERNAL with 4 functions and 1 procedure DBMS_CRYPTO_INTERNAL 16-Jul-2017
DBMS_CSX_INT2 with 2 objects DBMS_CSX_INT2 27-May-2017
DBMS_DATAPUMP_INT with 5 functions and 2 procedures DBMS_DATAPUMP_INT 13-May-2017
DBMS_DBCOMP with 1 procedure DBMS_DBCOMP 18-Mar-2017
DBMS_DISRUPT with 7 procedures DBMS_DISRUPT 18-Mar-2017
DBMS_FIX_CONTROL_PERSISTENCE with 4 objects DBMS_FIX_CONTROL_PERSISTENCE 05-Jun-2017
DBMS_GOLDENGATE_ADM with 12 objects DBMS_GOLDENGATE_ADM 12-Jun-2017
DBMS_GOLDENGATE_ADM_INTERNAL with 2 procedures DBMS_GOLDENGATE_ADM_INTERNAL 05-Jun-2017
DBMS_GOLDENGATE_ADM_INT_INVOK with 5 procedures DBMS_GOLDENGATE_ADM_INT_INVOK 25-Dec-2017
DBMS_GOLDENGATE_EXP with 1 object DBMS_GOLDENGATE_EXP 27-Jun-2017
DBMS_GOLDENGATE_IMP with 5 objects DBMS_GOLDENGATE_IMP 27-Jun-2017
DBMS_GSM_FIX with 3 objects DBMS_GSM_FIX 28-Dec-2017
DBMS_GSM_FIXED with 3 procedures and 1 function DBMS_GSM_FIXED 02-Jan-2018
DBMS_GSM_XDB with 1 objects DBMS_GSM_XDB 05-Jan-2018
DBMS_HADOOP with 2 procedures DBMS_HADOOP 18-Mar-2017
DBMS_HADOOP_INTERNAL with 1 procedure and 22 functions DBMS_HADOOP_INTERNAL 23-Jan-2018
DBMS_HANG_MANAGER with 1 procedure DBMS_HANG_MANAGER 10-Apr-2017
DBMS_HEAT_MAP_INTERNAL with 6 objects DBMS_HEAT_MAP_INTERNAL 13-Jun-2017
DBMS_HIERARCHY with 2 procedures and 2 functions DBMS_HIERARCHY 11-Apr-2017
DBMS_INMEMORY_ADMIN with 9 objects including 2 moved from DBMS_INMEMORY DBMS_INMEMORY_ADMIN 17-Apr-2017
DBMS_IREFSTATS with 6 procedures DBMS_IREFSTATS 28-Jan-2018
DBMS_ISCHED_REMOTE_ACCESS with 8 objects DBMS_ISCHED_REMOTE_ACCESS -
DBMS_JAVASCRIPT with 1 procedure DBMS_JAVASCRIPT 11-Apr-2017
DBMS_JSON with 12 objects DBMS_JSON 28-Aug-2017
DBMS_JSON0 with 3 procedures and 2 functions DBMS_JSON0 28-Aug-2017
DBMS_JSON_INT with 7 objects DBMS_JSON_INT 17-Oct-2017
DBMS_MANAGEMENT_BOOTSTRAP with 1 procedure DBMS_MANAGEMENT_BOOTSTRAP 13-Apr-2017
DBMS_MASTER_TABLE with 9 procedures and 1 function DBMS_MASTER_TABLE 29-May-2017
DBMS_MDX_ODBO (33 functions + many procs) DBMS_MDX_ODBO -
DBMS_MVIEW_STATS with 3 procedures one with 2 overloads DBMS_MVIEW_STATS 16-Apr-2017
DBMS_MVIEW_STATS_INTERNAL with 3 procedures one with 2 overloads DBMS_MVIEW_STATS_INTERNAL 16-Apr-2017
DBMS_PCLXUTIL_INTERNAL with one procedure DBMS_PCLXUTIL_INTERNAL 22-May-2017
DBMS_PDB_ALTER_SHARING with 7 procedures DBMS_PDB_ALTER_SHARING 26-Mar-2017
DBMS_PLSQL_CODE_COVERAGE with 6 procedures DBMS_PLSQL_CODE_COVERAGE 03-Apr-2017
DBMS_PQ_INTERNAL with 1 object DBMS_PQ_INTERNAL 25-May-2017
DBMS_PREPLUGIN_BACKUP with 7 new objects DBMS_PREPLUGIN_BACKUP 16-Apr-2017
DBMS_PROCESS with 3 new procedures DBMS_PROCESS 16-Apr-2017
DBMS_REGISTRY_EXTENDED DBMS_REGISTRY_EXTENDED 01-Mar-2018
DBMS_RLS_INT with 15 objects (prvtrlsa.plb) DBMS_RLS_INT 01-Feb-2018
DBMS_SCHED_CONSTRAINT_EXPORT with 6 objects DBMS_SCHED_CONSTRAINT_EXPORT -
DBSFWUSER.DBMS_SFW_ACL_ADMIN with 30 objects DBMS_SFW_ACL_ADMIN 13-Feb-2018
DBMS_SNAPSHOT_COMMON with 3 objects DBMS_SNAPSHOT_COMMON -
DBMS_SNAPSHOT_KKXRCA with 28 objects many of them with overloads DBMS_SNAPSHOT_KKXRCA -
DBMS_SODA_ADMIN_ with 10 objects DBMS_SODA_ADMIN -
DBMS_SODA_DML with 7 objects DBMS_SODA_DML -
DBMS_SODA_DOM with 16 objects DBMS_SODA_DOM -
DBMS_SODA_UTIL with 11 objects DBMS_SODA_UTIL -
DBMS_SPACE_ALERT with 5 objects DBMS_SPACE_ALERT 25-May-2017
DBMS_STATS_ADVISOR with 73 objects DBMS_STATS_ADVISOR 18-Aug-2017
DBSFWUSER.DBMS_SFW_ACL_ADMIN with 30 objects DBMS_SFW_ACL_ADMIN 07-Jun-2017
DBMS_SYNC_REFRESH_INTERNAL with 18 objects DBMS_SYNC_REFRESH_INTERNAL -
DBMS_TF with 8 objects, 3 with 2 overloads and 1 with 7 DBMS_TF 17-Apr-2017
DBMS_TG_DBG with 1 procedure DBMS_TG_DBG 22-Mar-2017
DBMS_TNS with one procedure DBMS_TNS 07-Feb-2017
DBMS_UMF with 16 objects some overloaded DBMS_UMF 19-Apr-2017
DBMS_UMF_INTERNAL with 21 objects DBMS_UMF_INTERNAL 19-Aug-2017
DBMS_UMF_PROTECTED with 9 objects DBMS_UMF_PROTECTED 14-May-2017
DBMS_WRR_PROTECTED with 2 functions DBMS_WRR_PROTECTED 02-Feb-2018
DBMS_WRR_STATE an orphan package header DBMS_WRR_STATE 25-May-2017
DBMS_XDB_UTIL with 1 object and 5 overloads DBMS_XDB_UTIL 03-Feb-2018
DRIACCHELP with 6 objects DRIACCHELP 04-Feb-2018
LBAC_EXP with 3 objects LBAC_EXP 29-Apr-2018
LBAC_LGSTNDBY_UTIL with 21 objects LBAC_LGSTNDBY_UTIL -
LTSYS with 114 objects LTSYS -
ORA_DM_REFCUR_PKG an orphan package header ORA_DM_REFCUR_PKG 27-May-2017
ORDERRORINT with 1 object ORDERRORINT 05-Feb-2018
ORD_AUDIO with 3 objects 2 with overloads ORD_AUDIO 12-Feb-2018
ORD_DOC with 3 objects 2 with overloads ORD_DOC -
ORD_IMAGE with 17 objects many with overloads ORD_IMAGE -
OWM_CPKG_PKG with 1 procedure OWM_CPKG_PKG 10-Oct-2017
PRIVATE_JDBC_DR with 1 function PRIVATE_JDBC_DR 08-Nov-2017
PRVTEMX_RSRCMGR PRVTEMX_RSRCMGR -
PRVTEMX_SQL PRVTEMX_SQL 07-May-2018
XDB_METADATA_CONSTANTS XDB_METADATA_CONSTANTS 28-Aug-2017
 
Built-in Packages with New or Removed Functions and Procedures
AS_REPLAY has dropped the END_AS_REPLAY and START_REPLAY procedures AS_REPLAY 28-Mar-2017
CDBVIEW has a new GETLONG function CDBVIEW 29-Jan-2017
CTX_DDL has new ADD_FILTER_SECTION and REMOVE_OVERLAP_DOLLARS objects CTX_DDL 17-May-2017
DBMS_ADR has dropped CLEANOUT_SCHEMA, DOWNGRADE_SCHEMA,
MIGRATE_SCHEMA & RECOVER_SCHEMA
DBMS_ADR 28-Mar-2017
DBMS_ADR has added the new RUN_PURGE and SET_TRACEFILE_IDENTIFIER procedures DBMS_ADR 28-Mar-2017
DBMS_ADR_APP has added the new RUN_PURGE and SET_TRACEFILE_IDENTIFIER procedures DBMS_ADR_APP 28-Mar-2017
DBMS_ADR_INTERNAL has added the new RUN_PURGE and SET_TRACEFILE_IDENTIFIER procedures DBMS_ADR_INTERNAL 28-Mar-2017
DBMS_AQ has 3 new ..._PAS procedures DBMS_AQ 15-Jul-2017
DBMS_AQADM has 7 new objects DBMS_AQADM 17-Aug-2017
DBMS_ASH_INTERNAL has new GET_CPUINFO_XML procedure DBMS_ASH_INTERNAL 18-May-2017
DBMS_AUDIT_MGMT has new TRANSFER_UNIFIED_AUIT_RECORDS procedure DBMS_AUDIT_MGMT 27-Oct-2016
DBMS_AW has new VALIDATE_AW_NAME procedure DBMS_AW 15-Jul-2017
DBMS_AWR_REPORT_LAYOUT has 2 new DIFF_EXA_ procedures DBMS_AWR_REPORT_LAYOUT 20-May-2017
DBMS_BACKUP_RESTORE has 25 new functions and procedures DBMS_BACKUP_RESTORE 16-Jul-2017
DBMS_CDC_UTILITY has PURGEMVLOGLOGICAL, PURGEMVLOGPHYSICAL, QCCGSCN removed DBMS_CDC_UTILITY 19-Aug-2017
DBMS_COMPRESSION has new CLEAR_ANALYSIS DBMS_COMPRESSION 19-Aug-2017
DBMS_CSX_ADMIN has 6 new objects DBMS_CSX_ADMIN 01-May-2017
DBMS_DATAPUMP has new GET_OBJECT_INFO, STOP_WORKER, TEST_FUNCTIONALITY objects DBMS_DATAPUMP 22-Aug-2017
DBMS_DBFS_CONTENT has 4 new objects DBMS_DBFS_CONTENT 24-Aug-2017
DBMS_DBFS_CONTENT_ADMIN has 5 new objects DBMS_DBFS_CONTENT_ADMIN 18-Jul-2017
DBMS_DBFS_SFS has 4 new procedures DBMS_DBFS_SFS 27-Aug-2017
DBMS_DNFS has new UNMOUNTVOLUME procedure DBMS_DNFS 12-Dec-2016
DBMS_DRS has new STARTUP_FOR_RELOCATE procedure DBMS_DRS 19-Jul-2017
DBMS_DST has new GET_LATEST_TIMEZONE_VERSION function DBMS_DST 28-Aug-2017
DBMS_GSM_CLOUDADMIN with 7 new objects DBMS_GSM_CLOUDADMIN 05-Jan-2018
DBMS_GSM_DBADMIN with 21 new objects DBMS_GSM_DBADMIN 29-Dec-2017
DBMS_GSM_POOLADMIN with 43 new objects two with overloads DBMS_GSM_POOLADMIN 16-Jan-2018
DBMS_GSM_UTILITY with 31 new objects DBMS_GSM_UTILITY 11-Jan-2018
DBMS_ILM has new FLUSH_COL_STATS procedure DBMS_ILM 26-Sep-2017
DBMS_INMEMORY has new IME_DROP_EXPRESSIONS and
SEGMENT_DEALLOCATE_VERSION procedures
DBMS_INMEMORY 17-Apr-2017
DBMS_INMEMORY moved DISABLEFASTSTART and ENABLEFASTSTART
to DBMS_INMEMORY_ADMIN package
DBMS_INMEMORY 17-Apr-2017
DBMS_INTERNAL_CLKM has 1 new objects DBMS_INTERNAL_CLKM 28-Jan-2018
DBMS_INTERNAL_LOGSTDBY has 4 new objects DBMS_INTERNAL_LOGSTDBY 31-Aug-2017
DBMS_INTERNAL_LOGSTDBY has removed CREATE_FUTURE_SESSION
and DESTROY_FUTURE_SESSION objects
DBMS_INTERNAL_LOGSTDBY 31-Aug-2017
DBMS_IREFRESH has new REFGROUP, USER_EXPORT, and USER_EXPORT_CHILD objects DBMS_IREFRESH 28-Jan-2018
DBMS_ISCHED has AGENT_INSTALL_POST_STEPS,  AGENT_INSTALL_PRE_STEPS,
RESET_JOBSUFFIX_SEQ
DBMS_ISCHED 22-Jul-2017
DBMS_LOB has new CLOB2FILE and ISREMOTE objects DBMS_LOB 11-Sep-2017
DBMS_METADATA has new GET_PLSQL_OPTIMIZ_LEVEL and
IS_ACTIVE_REGISTRATION functions
DBMS_METADATA 11-Sep-2017
DBMS_METADATA_DPBUILD has new SET_DEBUG procedure DBMS_METADATA_DPBUILD 24-Jan-2017
DBMS_METADATA_INT has new SET_TRANSFORM_ENGINE procedure DBMS_METADATA_INT 14-Sep-2017
DBMS_PDB has 8 new procedures and 2 new functions DBMS_PDB 07-Dec-2016
DBMS_PLUGTSP has the KCP_PD and KCP_PTMD procedures removed DBMS_PLUGTSP 05-Mar-2017
DBMS_PRIVILEGE_CAPTURE has new CAPTURE_DEPENDENCY_PRIVS and DELETE_RUN procedures DBMS_PRIVILEGE_CAPTURE 25-Jul-2017
DBMS_PRIV_CAPTURE has new SES_HAS_OBJ_PRIV function DBMS_PRIV_CAPTURE 20-Sep-2017
DBMS_PRIV_CAPTURE has dropped 4 HAS_OBJ_PRIV, 3 HAS_ROLE_PRIV,  4 HAS_SYS_PRIV functions DBMS_PRIV_CAPTURE 20-Sep-2017
DBMS_QOPATCH has CONFIG_OINV_JOBS, OPATCH_RUN_JOB, REFRESH_OPATCH_DATA removed DBMS_QOPATCH 25-Jul-2017
DBMS_QOPATCH has 6 new objects DBMS_QOPATCH 25-Jul-2017
DBMS_RCVMAN has 15 new objects DBMS_RCVMAN 24-Jul-2017
DBMS_REDACT has new 4 new objects DBMS_REDACT 21-Sep-2017
DBMS_REDEFINITION_INTERNAL has IS_INDEX_ON_NESTED_TAB function removed DBMS_REDEFINITION_INTERNAL 29-Sep-2017
DBMS_REDEFINITION_INTERNAL has 46 new objects DBMS_REDEFINITION_INTERNAL 29-Sep-2017
DBMS_REPORT has new GET_AWR_DIFF_CONTEXT procedure DBMS_REPORT 03-Oct-2017
DBMS_REPUTIL: All objects removed except REPLICATION_IS_ON, _OFF and _ON DBMS_REPUTIL 08-Apr-2017
DBMS_RESOURCE_MANAGER has new 2 new objects DBMS_RESOURCE_MANAGER 06-Oct-2017
DBMS_RESULT_CACHE has new 4 new objects DBMS_RESULT_CACHE 16-Oct-2017
DBMS_SCHEDULER has 8 new objects DBMS_SCHEDULER 29-May-2017
DBMS_SERVICE_PRVT has new GET_TOPOLOGY and IS_JAVA_SERVICE functions DBMS_SERVICE_PRVT 17-Jul-2017
DBMS_SPACE_ADMIN has 2 new procs DBMS_SPACE_ADMIN 26-Oct-2017
DBMS_SPM_INTERNAL has dropped the FETCH_PLAN_INFO and GET_SPM_HINTSET functions DBMS_SPM_INTERNAL 15-Nov-2017
DBMS_SPM_INTERNAL has 18 new objects DBMS_SPM_INTERNAL 15-Nov-2017
DBMS_SQLDIAG has one new procedure with 2 overloads DBMS_SQLDIAG 19-Feb-2018
DBMS_SQLDIAG_INTERNAL drop the I_CREATE_PATCH function and replaces it with an overloaded proc of the same name DBMS_SQLDIAG_INTERNAL 29-May-2017
DBMS_SQLPA has new SET_QUICK_CHECK_TASK function DBMS_SQLPA 27-Oct-2017
DBMS_SQLPATCH has 5 new objects DBMS_SQLPATCH 26-Jul-2017
DBMS_SQLTUNE_UTIL0 has 4 new objects DBMS_SQLTUNE_UTIL0 30-Oct-2017
DBMS_SQLTUNE_UTIL1 has 16 new objects DBMS_SQLTUNE_UTIL1 30-Oct-2017
DBMS_SQLTUNE_UTIL2 has 6 new objects DBMS_SQLTUNE_UTIL2 30-Oct-2017
DBMS_SQL_TRANSLATOR has CLEAR_SQL_TRANSLATION_ERROR and SET_DICTIONARY_SQL_ID procedures DBMS_SQL_TRANSLATOR 19-Nov-2017
DBMS_STANDARD has new ORA_MAX_NAME_LEN_SUPPORTED function DBMS_STANDARD 26-Jun-2017
DBMS_STATS has 20 new objects DBMS_STATS 06-Aug-2017
DBMS_STATS_INTERNAL dropped ALTER_COL_TRACKING_LEVEL, EST_SYNOPSIS_SIZE,
GENERATE_GROUP_LEVEL_SYNOPSIS, IS_PARTGRP_ONE_TO_ONE, POPULATE_SYNOPSIS_PARTGRP
DBMS_STATS_INTERNAL 06-Aug-2017
DBMS_STATS_INTERNAL has 96 new objects DBMS_STATS_INTERNAL 06-Aug-2017
DBMS_STREAMS has new COMPATIBLE_12_2 function DBMS_STREAMS 04-Jun-2017
DBMS_STREAMS_ADM has new DELETE_REPLICATION_EVENTS procedure DBMS_STREAM_ADM 03-Nov-2017
DBMS_SWRF_INTERNAL dropped the CREATE_SYSAWR_USER and GRANT_PRIV_STAGING_SCHEMA procedures DBMS_SWRF_INTERNAL 10-Nov-2017
DBMS_SWRF_INTERNAL has new DEFAULT_REPORT_DBID, REMOVE_ADDM_TASKS, RESET_AWR, and VALIDATE_AWR_LOCATION objects DBMS_SWRF_INTERNAL 10-Nov-2017
DBMS_SYSTEM has new GET_OBH function DBMS_SYSTEM 14-Nov-2017
DBMS_SYS_SQL has BIND_VARIABLE_PKG and VARIABLE_VALUE_PKG procedures DBMS_SYS_SQL 15-Nov-2017
DBMS_TTS has new CONVERTENCRYPTEDDATAFILECOPY and GET_AFN_IDBXENDIAN procedures DBMS_TTS 12-Aug-2017
DBMS_UTILITY has new INIT_NUMBER_ARRAY function DBMS_UTILITY 03-Sep-2017
DBMS_WLM has new 5 new objects DBMS_WLM 08-Aug-2017
DBMS_WRR_INTERNAL drops the INVOKE_GET_PATH function and gains 15 new objects DBMS_WRR_INTERNAL 12-Nov-2017
DBMS_XDB_ADMIN drops 6 objects DBMS_XDB_ADMIN 20-Nov-2017
DBMS_XDB_CONFIG contains 8 new objects DBMS_XDB_CONFIG 17-Aug-2017
DBMS_XSTREAM_AUTH_IVK contains 3 new objects DBMS_XSTREAM_AUTH_IVK 12-Dec-2017
DBMS_XSTREAM_GG contains 3 new objects DBMS_XSTREAM_GG 13-Dec-2017
DM_QGEN drops the GI_GEN, CI_GEN, LS_APPEND, and LS_PREPEND objects DM_QGEN 13-Dec-2017
DM_QGEN  adds EXT_QUOTE, SQLN2BND, SQLN2LIT, SQLN2QSQL, and SQLN2SQL objects DM_QGEN 13-Dec-2017
KUPP$PROC has new 5 new objects and SET_DEBUG is dropped KUPP$PROC 13-Aug-2017
PRVTEMX_ADMIN has new REPORT_ALTER_TBS_INMEMORY_XML and REPORT_DBSEARCH_XML functions PRVTEMX_ADMIN 14-Aug-2017
PRVTEMX_CELL has new REPORT_CELL_DIFF and REPORT_CELL_DIFF_XML functions PRVTEMX_CELL 14-Aug-2017
WM_ERROR has new GETERRORSTR function WM_ERROR 27-Jun-2017
 
Built-in Packages with New or Removed Overloads
DBMS_DATAPUMP.GET_STATUS has 1 new overload DBMS_DATAPUMP 22-Aug-2017
DBMS_GSM_DBADMIN.ADDDATABASE has 1 new overload DBMS_GSM_DBADMIN 29-Dec-2017
DBMS_GSM_UTILITY.GENERATECHANGELOGENTRY has a new overload DBMS_GSM_UTILITY 11-Jan-2018
DBMS_HPROF.ANALYZE has 2 new overloads, STOP_PROFILING has 1 new overload DBMS_HPROF 22-Dec-2016
DBMS_RCVMAN has new overloads in GETRESTOREPOINT, LISTGETRESTOREPOINT, LISTGETTABLESPACE DBMS_RCVMAN 24-Jul-2017
 
Built-in Packages with Parameters Changes
DBMS_ADR.SET_LOG_MSG_TEMPLATE and WRITE_LOG have 3 new container database related parameters DBMS_ADR 28-Mar-2017
DBMS_ADR_APP.SET_LOG_MSG_TEMPLATE and WRITE_LOG have 3 new container database related parameters DBMS_ADR_APP 28-Mar-2017
DBMS_ADR_INTERNAL.WRITE_LOG_HANDLER has 3 new container database related parameters DBMS_ADR_INTERNAL 18-Mar-2017
DBMS_ADVISOR.EXECUTE_TASK overload 2 has 2 new parameters DBMS_ADVISOR 18-Mar-2017
DBMS_COMPRESSION has new GET_COMPRESSION_TYPE parameter DBMS_COMPRESSION 16-Dec-2017
DBMS_CONNECTION_POOL.CONFIGURE_POOL has 1 new parameters DBMS_CONNECTION_POOL 17-Nov-2016
DBMS_GSM_CLOUDADMIN.ADDVNCR has one new overload DBMS_GSM_CLOUDADMIN 05-Jan-2018
DBMS_METADATA.SET_TRANSFORM_PARAM, all overloads, has new FLAGS parameter and many new constants DBMS_METADATA 11-Sep-2017
DBMS_PART.CLEANUP_GIDX_INTERNAL has new NOOP_OKAY_IN parameter DBMS_PART 18-Feb-2017
DBMS_PRIVILEGE_CAPTURE has new RUN_NAME and DEPENDENCY parameters DBMS_PRIVILEGE_CAPTURE 14-Mar-2017
DBMS_SERVICE_PRVT.STOP_SERVICE 3 new parameters: STOP_OPTION,
DRAIN_TIMEOUT, and REPLAY
DBMS_SERVICE_PRVT 17-Jul-2017
DBMS_SNAPSHOT has new parameters in a number of objects DBMS_SNAPSHOT 26-May-2017
DBMS_SYS_SQL has 29 new overloads as part of a number of package objects DBMS_SYS_SQL 15-Nov-2017
UTL_TCP.SECURE_CONNECTION has new SECURE_HOST parameter UTL_TCP 12-Jan-2017
 
Built-in Packages with new Constants, Exceptions, Types, and other significant changes
DBMS_DATAPUMP has new KU$_STATUS_VERSION_5 and 5 new KU$_DATAOPT constants DBMS_DATAPUMP 22-Aug-2017
DBMS_DB_VERSION DBMS_DB_VERSION 26-May-2017
DBMS_HEAT_MAP has new data types DBMS_HEAT_MAP 13-Jun-2017
DBMS_ILM has new ILM_ALL_EXECUTIONS constant DBMS_ILM 17-Dec-2017
DBMS_REDACT has new 17 new constants DBMS_REDACT 21-Sep-2017
DBMS_SQLTUNE_UTIL0 has new constants and data type DBMS_SQLTUNE_UTIL0 30-Oct-2017
DBMS_STANDARD has new ORA_MAX_NAME_LEN constant DBMS_STANDARD 26-Jun-2017
 
Related Topics
New in 11.2.0.3
New in 12.1.0.2
New in 18.3.0.1
  Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved