| New In Oracle Database Version 23c |
|---|
| Description | Link | Last Modified |
| General | ||
| This page is currently in the process of being configured and finalized which will likely take several weeks to accomplish.
If links aren't working correctly and pointing at the right 23c content do not be surprised. Contents are based on work with 23.1 (Beta 1) and 23.2 and .3 (Developer Release AKA Beta 2and 3). Expect changes to take place regularly and often. |
||
| Architecture | ||
New Background Processes
|
Background Processes | 01-May-2023 |
New Objects
|
ANNOTATIONS DOMAINS |
30-Jul-2023 20-Jan-2024 |
| Oracle Machine Learning (OML) | - | - |
| TBD | - | - |
| Security | ||
| Read Only Users | USERS | 01-May-2023 |
| Schema Level Object Privileges Grants (these are a violation of the Principle of Least Privilege) | Object Privileges | 01-May-2023 |
| Schema Level System Privilege Grants (these are a violation of the Principle of Least Privilege) | System Privileges | 01-May-2023 |
| - | - | |
| Basic | ||
New Users
|
USERS | 01-May-2023 |
New Roles (25 new roles since 19c, the following list is new since 21c)
|
ROLES | 04-Jun-2023 |
New System Privileges (25 new privileges since 19c, the following list is new since 21c)
|
SYSTEM PRIVILEGES | 13-Feb-2024 |
New Dynamic Performance Views
|
Dynamic Performance Views | - |
New Object Privileges (3 new privileges since 19c, the following list is new since 21c)
|
OBJECT PRIVILEGES | 01-May-2023 |
New Hints
|
- | - |
New Initialization Parameters (63 since 19c)
|
Startup Parameters | 14-Feb-2024 |
New Underscore Initialization Parameters
|
??? | - |
| Annotations Support | - | 01-May-2023 |
| Enhanced Exceptions providing more granular, and useful, messages | - | 01-May-2023 |
| Table support for the BOOLEAN data type | TABLES | 01-May-2023 |
| Other Deprecated, Desupported or Dropped Objects | ||
| DBMS_FEATURE_EMX | - | 13-Jun-2023 |
| DBMS_FEATURE_REGISTER_ALLFEAT | - | 13-Jun-2023 |
| DBMS_FEATURE_REGISTER_ALLHWM | - | 13-Jun-2023 |
| Object Types and Features | ||
New
|
- | - |
| New SQL | ||
| "FROM dual" no longer required in SQL queries | SELECT | 01-May-2023 |
| GROUP BY now accepts column aliases | GROUP BY | 01-May-2023 |
| DDL statements accept the logical argument IF [NOT] EXISTS | DDL | 01-May-2023 |
| RETURNING clause support for MERGE statements | MERGE | 01-May-2023 |
| RETURNING OLD clause supported with UPDATE statements | UPDATE | 01-May-2023 |
| Tables with up to 4096 columns: If you need more than 200 sign up for "SQL Basics for Dummies" | - | 01-May-2023 |
| Table Value Constructors allowed in single DML and SELECT statements providing ISO support | DML | 01-May-2023 |
| UPDATE based on a join condition | UPDATE | 01-May-2023 |
| PL/SQL Changes | ||
| JavaScript MLE MODULES bypassing direct calls to the DBMS_MLE built-in package | Java Script | 01-May-2023 |
| New, Modified and Dropped Functions, Operators, Procedures, and Types | ||
| DBMS_FEATURE_ADBDCAT | DBMS_FEATURE Procedures | 13-Jun-2023 |
| DBMS_FEATURE_ADBXTTAB | DBMS_FEATURE Procedures | 13-Jun-2023 |
| DBMS_FEATURE_JOB_CLOUDSQL | DBMS_FEATURE Procedures | 13-Jun-2023 |
| DBMS_FEATURE_EMX Dropped | DBMS_FEATURE Procedures | 13-Jun-2023 |
| DBMS_FEATURE_REGISTER_ALLFEAT Dropped | DBMS_FEATURE Procedures | 13-Jun-2023 |
| DBMS_FEATURE_REGISTER_ALLHWM Dropped | DBMS_FEATURE Procedures | 13-Jun-2023 |
| DBMS_FEATURE_MLE | DBMS_FEATURE Procedures | 13-Jun-2023 |
| DBMS_FEATURE_USER_DV | DBMS_FEATURE Procedures | 13-Jun-2023 |
| SYS_CONTEXT added new CDB_DOMAIN, CLOUD_SERVICE, and DRAIN_STATUS options | DBMS_FEATURE Procedures | 16-Jan-2024 |
| SYS_CONTEXT dropped the EXTERNAL_NAME option | DBMS_FEATURE Procedures | 16-Jan-2024 |
| Renamed Objects | ||
| TBD | - | - |
| New or Modified Functions, Operators, Procedures, and Types | ||
| TBD | - | - |
| Changes to JSON, SODA and XML | ||
| JSON Schema Definition validation | JSON | 01-May-2023 |
| New Built-in Packages | ||
| DBMS_ADAT_REPORT | DBMS_ADAT_REPORT | 01-May-2023 |
| DBMS_APPLICATION | DBMS_APPLICATION | 21-Jun-2023 |
| DBMS_AQMIGTOOL | DBMS_AQMIGTOOL | 01-May-2023 |
| DBMS_AQMIGTOOL_SYS | DBMS_AQMIGTOOL_SYS | 01-May-2023 |
| DBMS_AUTOIM | DBMS_AUTOIM | 01-May-2023 |
| DBMS_AUTOIM_INTERNAL | DBMS_AUTOIM_INTERNAL | 01-May-2023 |
| DBMS_AUTO_CLUSTERING | DBMS_AUTO_CLUSTERING | 01-May-2023 |
| DBMS_AUTO_CLUSTERING_INTERNAL | DBMS_AUTO_CLUSTERING_INTERNAL | 01-May-2023 |
| DBMS_CLOUD_DBLINK | DBMS_CLOUD_DBLINK | 17-Dec-2023 |
| DBMS_CLOUD_DBLINK_INTERNAL | DBMS_CLOUD_DBLINK_INTERNAL | 17-Dec-2023 |
| DBMS_DATA_GUARD | DBMS_DATA_GUARD | 01-May-2023 |
| DBMS_DATA_GUARD_INTERNAL | DBMS_DATA_GUARD_INTERNAL | 01-May-2023 |
| DBMS_DGPDB | DBMS_DGPDB | 01-May-2023 |
| DBMS_DICTIONARY_CHECK | DBMS_DICTIONARY_CHECK | 29-Jan-2024 |
| DBMS_GSM_CURUSER | DBMS_GSM_CURUSER | 01-May-2023 |
| DBMS_GSM_GSMUSER | DBMS_GSM_GSMUSER | 01-May-2023 |
| DBMS_GSM_SHDUSR | DBMS_GSM_SHDUSR | 09-Jun-2023 |
| DBMS_GSM_VPD | DBMS_GSM_VPD | 09-Jun-2023 |
| DBMS_HASH | DBMS_HASH | 29-Jan-2024 |
| DBMS_INMEMORY_ADVISE | DBMS_INMEMORY_ADVISE | 29-Jan-2024 |
| DBMS_JSON_DUALITY | DBMS_JSON_DUALITY | 04-May-2023 |
| DBMS_JSON_SCHEMA | DBMS_JSON_SCHEMA | 04-May-2023 |
| DBMS_KAFKA | DBMS_KAFKA | 01-May-2023 |
| DBMS_KAFKA_ADM | DBMS_KAFKA_ADM | 01-May-2023 |
| DBMS_KAFKA_INT | DBMS_KAFKA_INT | 01-May-2023 |
| DBMS_KAFKA_MD | DBMS_KAFKA_MD | 01-May-2023 |
| DBMS_KAFKA_UTL | DBMS_KAFKA_UTL | 01-May-2023 |
| DBMS_MANAGEMENT_DIAGNOSTICS | DBMS_MANAGEMENT_DIAGNOSTICS | 01-May-2023 |
| DBMS_NOTIFICATIONS | DBMS_NOTIFICATIONS | 28-May-2023 |
| DBMS_PART_INTERNAL | DBMS_PART_INTERNAL | 05-Jun-2023 |
| DBMS_REDACTOR | DBMS_REDACTOR | 28-May-2023 |
| DBMS_ROUTER_ADMIN | DBMS_ROUTER_ADMIN | 21-Jun-2023 |
| DBMS_ROW_CHANGE_TRACKING | DBMS_ROW_CHANGE_TRACKING | 28-May-2023 |
| DBMS_ROW_CHANGE_TRACKING_INT | DBMS_ROW_CHANGE_TRACKING_INT | 28-May-2023 |
| DBMS_SAGA | DBMS_SAGA | 04-Jun-2023 |
| DBMS_SAGA_ADM | DBMS_SAGA_ADM | 04-Jun-2023 |
| DBMS_SAGA_ADM_SYS | DBMS_SAGA_ADM_SYS | 04-Jun-2023 |
| DBMS_SAGA_CONNECT_INT | DBMS_SAGA_CONNECT_INT | 04-Jun-2023 |
| DBMS_SAGA_SYS | DBMS_SAGA_SYS | 04-Jun-2023 |
| DBMS_SEARCH | DBMS_SEARCH | 05-Feb-2024 |
| DBMS_SENSITIVE_DATA | DBMS_SENSITIVE_DATA | 30-Jan-2024 |
| DBMS_SHARDING_DIRECTORY | DBMS_SHARDING_DIRECTORY | 10-Jun-2023 |
| DBMS_SHARED_CAPTURE_ADM | DBMS_SHARED_CAPTURE_ADM | 08-Jun-2023 |
| DBMS_SHARED_CAPTURE_INTERNAL | DBMS_SHARED_CAPTURE_INTERNAL | 08-Jun-2023 |
| DBMS_SHARED_CAPTURE_IVK | DBMS_SHARED_CAPTURE_IVK | 08-Jun-2023 |
| DBMS_SQLHIST | DBMS_SQLHIST | 30-Jan-2024 |
| DBMS_SQLHIST_INTERNAL | DBMS_SQLHIST_INTERNAL | 30-Jan-2024 |
| DBMS_SQL_FIREWALL | DBMS_SQL_FIREWALL | 31-May-2023 |
| DBMS_SWAT_XML | DBMS_SWAT_XML | 06-Jun-2023 |
| DBMS_TABLE_FUNC | DBMS_TABLE_FUNC | 30-Jan-2024 |
| DBMS_UPG_JSON | DBMS_UPG_JSON | 06-Jun-2023 |
| DBMS_UPG_JSON0 | DBMS_UPG_JSON0 | 06-Jun-2023 |
| DBMS_UPG_JSON_INT | DBMS_UPG_JSON_INT | 06-Jun-2023 |
| DBMS_USERDIAG | DBMS_USERDIAG | 06-Jun-2023 |
| LTDEFINER | LTDEFINER | 04-Jun-2023 |
| PRVT_DBMS_INMEMORY_ADVISOR | PRVT_DBMS_INMEMORY_ADVISOR | 30-Jan-2024 |
| PRVT_ILM_INVOKERS_RIGHTS | PRVT_ILM_INVOKERS_RIGHTS | 07-Jun-2023 |
| PRVT_UTILITY | PRVT_UTILITY | 02-May-2023 |
| TSDP_ERROR_HANDLE | TSDP_ERROR_HANDLE | 30-Jan-2024 |
| Removed Built-in Packages | ||
| BSLN | - | 09-Jun-2023 |
| CARTRIDGE | - | 09-Jun-2023 |
| CTX_TREE | - | 09-Jun-2023 |
| DBMS_EDITIONS_UTILITIES2 | - | 10-Jun-2023 |
| DBMS_FILE_GROUP | - | 29-Jan-2024 |
| DBMS_FILE_GROUP_DECL | - | 29-Jan-2024 |
| DBMS_FILE_GROUP_EXP | - | 29-Jan-2024 |
| DBMS_FILE_GROUP_EXP_INTERNAL | - | 29-Jan-2024 |
| DBMS_FILE_GROUP_IMP_INTERNAL | - | 29-Jan-2024 |
| DBMS_FILE_GROUP_INTERNAL_INVOK | - | 29-Jan-2024 |
| DBMS_FILE_GROUP_UTIL | - | 29-Jan-2024 |
| DBMS_FILE_GROUP_UTIL_INVOK | - | 29-Jan-2024 |
| DBMS_HS_PARALLEL | - | 15-Jun-2023 |
| DBMS_HS_PARALLEL_METADATA | - | 15-Jun-2023 |
| DBMS_JAVASCRIPT | - | 29-Jan-2024 |
| DBMS_PREUP (check $ORACLE_HOME/rdbms/admin/catupstr_checks.sql) | - | 26-Jun-2023 |
| DBMS_WRR_STATE_BASE present in 20c, dropped from 23c | - | 01-May-2023 |
| IM | - | 09-Jun-2023 |
| MGMT_CONFIG | - | 09-Jun-2023 |
| MGMT_CONFIG_UTL | - | 09-Jun-2023 |
| MGMT_DB_LL_METRICS | - | 09-Jun-2023 |
| MGMT_RESPONSE | - | 09-Jun-2023 |
| MGWI_ADMIN | - | 09-Jun-2023 |
| MGWI_CONST | - | 09-Jun-2023 |
| MGWI_CRYPTO | - | 09-Jun-2023 |
| MGWI_REG | - | 09-Jun-2023 |
| OLS_DIP_NTFY | - | 08-Aug-2023 |
| ORDAUDIOEXCEPTIONS | - | 09-Jun-2023 |
| ORDAUDIO_PKG | - | 09-Jun-2023 |
| ORDDOCEXCEPTIONS | - | 09-Jun-2023 |
| ORDDOC_PKG | - | 09-Jun-2023 |
| ORDERROR | - | 09-Jun-2023 |
| ORDERRORINT | - | 09-Jun-2023 |
| ORDEXCEPTIONS | - | 09-Jun-2023 |
| ORDIMAGECONSTANTS | - | 09-Jun-2023 |
| ORDIMAGESICONSTANTS | - | 09-Jun-2023 |
| ORDDIMERRORCODES | - | 09-Jun-2023 |
| ORDDIM_PKG | - | 09-Jun-2023 |
| ORDDIMGEXTCODEC_PKG | - | 09-Jun-2023 |
| ORDPLSGWYUTIL | - | 09-Jun-2023 |
| ORDSOURCEEXCEPTIONS | - | 09-Jun-2023 |
| ORDUTIL | - | 09-Jun-2023 |
| ORDUTIL_PRV | - | 09-Jun-2023 |
| ORDVIDEOEXCEPTIONS | - | 09-Jun-2023 |
| ORDVIDEO_PKG | - | 09-Jun-2023 |
| ORDX_DEFAULT_AUDIO | - | 09-Jun-2023 |
| ORDX_DEFAULT_DOC | - | 09-Jun-2023 |
| ORDX_DEFAULT_VIDEO | - | 09-Jun-2023 |
| ORDX_FILE_SOURCE | - | 09-Jun-2023 |
| ORDX_HTTP_SOURCE | - | 09-Jun-2023 |
| ORD_AUDIO | - | 09-Jun-2023 |
| ORD_DATASOURCE_PKG | - | 09-Jun-2023 |
| ORD_DICOM | - | 09-Jun-2023 |
| ORD_DICOM_ADMIN | - | 09-Jun-2023 |
| ORD_DOC | - | 09-Jun-2023 |
| ORD_IMAGE | - | 09-Jun-2023 |
| ORD_VIDEO | - | 09-Jun-2023 |
| PRVT_DBMS_MANAGE_XMLSTORAGE | - | 28-Jan-2024 |
| REDO_DIFF | - | 09-Jun-2023 |
| TKHCS_LOG_PKG | - | 09-Jun-2023 |
| UTL_RECOMP2 | - | 10-Jun-2023 |
| Built-in Packages with New or Removed Objects | ||
| CTX_ADM has removed the SHUTDOWN, STOP_OPTIMIZE and TEST_EXTPROC procedures | CTX_ADM | 26-Feb-2024 |
| DBMS_ADDM has 2 new objects related to failed auto tasks | DBMS_ADDM | 01-May-2023 |
| DBMS_AQADM_SYSCALLS has 7 new subprograms | DBMS_AQADM_SYSCALLS | 20-Dec-2023 |
| DBMS_AUTOTASK_PRVT has 5 new subprograms | DBMS_AUTOTASK_PRVT | 01-Dec-2023 |
| DBMS_AUTO_REPORT has 4 new subprograms | DBMS_AUTO_REPORT | 30-Mar-2024 |
| DBMS_AUTO_TASK has 2 new asynchronous operation functions | DBMS_AUTO_TASK | 01-May-2023 |
| DBMS_AUTO_TASK_ADMIN has 4 new procedures | DBMS_AUTO_TASK_ADMIN | 01-May-2023 |
| DBMS_AVTUNE has new 5 new objects | DBMS_AVTUNE | 01-May-2023 |
| DBMS_AWRHUB has 5 new objects | DBMS_AWRHUB | 05-May-2023 |
| DBMS_AWRHUB_SERVER has 3 new objects | DBMS_AWRHUB_SERVER | 01-May-2023 |
| DBMS_AWRHUB_SOURCE has 2 new objects | DBMS_AWRHUB_SOURCE | 05-May-2023 |
| DBMS_AWR_ANALYTICS has 3 new objects | DBMS_AWR_ANALYTICS | 28-May-2023 |
| DBMS_AWR_WAREHOUSE_SERVER has 2 new CLEANUP_ORPHAN procedures | DBMS_AWR_WAREHOUSE_SERVER | 25-Sep-2023 |
| DBMS_AWR_WAREHOUSE_SOURCE has new MODIFY_PACKAGING_METHOD procedure | DBMS_AWR_WAREHOUSE_SOURCE | 09-Sep-2023 |
| DBMS_BLOCKCHAIN_TABLE has 12 new objects | DBMS_BLOCKCHAIN_TABLE | 01-May-2023 |
| DBMS_CLOUD has 3 new objects | DBMS_CLOUD | 17-Dec-2023 |
| DBMS_CLOUD_ADMIN_INTERNAL has 2 new objects | DBMS_CLOUD_ADMIN_INTERNAL | 17-Dec-2023 |
| DBMS_CLOUD_CORE has new GET_DB_VERSION procedure | DBMS_CLOUD_CORE | 17-Dec-2023 |
| DBMS_CLOUD_REQUEST has new REFRESH_RESOURCE_PRINCIPAL | DBMS_CLOUD_REQUEST | 17-Dec-2023 |
| DBMS_CONNECTION_POOL has new ADD_POOL and REMOVE_POOL procedures | DBMS_CONNECTION_POOL | 26-Feb-2024 |
| DBMS_CUBE_PRVTEXP has new CLOB2FILE and GETCONTENTCLOB subobjects | DBMS_CUBE_PRVTEXP | 27-Jan-2024 |
| DBMS_DESCRIBE has new DATA_TYPE_TO_ID function | DBMS_DESCRIBE | 21-Apr-2024 |
| DBMS_DUMA_INTERNAL has 4 new objects | DBMS_DUMA_INTERNAL | 13-Jun-2023 |
| DBMS_FEATURE_USAGE has new REGISTER_ALL_FEATURES procedure | DBMS_FEATURE_USAGE | 27-Mar-2024 |
| DBMS_FS has new FS_EXISTS and LIST_FILES functions | DBMS_FS | 25-Sep-2023 |
| DBMS_GSM_FIXED has 20 new subprograms | DBMS_GSM_FIXED | 08-Apr-2024 |
| DBMS_GSM_SEC has 8 new sunptograms | DBMS_GSM_SEC | 28-May-2023 |
| DBMS_HCS_LOG has new SET_LOGGING_LEVEL procedure | DBMS_HCS_LOG | 22-Apr-2024 |
| DBMS_HEAT_MAP_INTERNAL dropped BLOCK_HEAT_MAP procedure | DBMS_HEAT_MAP_INTERNAL | 22-Apr-2024 |
| DBMS_HEAT_MAP_INTERNAL has 3 new subprograms | DBMS_HEAT_MAP_INTERNAL | 22-Apr-2024 |
| DBMS_IMMUTABLE_TABLE has new ADD_INTERVAL_PARTITIONING procedure | DBMS_IMMUTABLE_TABLE | 01-May-2023 |
| DBMS_INMEMORY has new POPULATE_GRAPH and REPOPULATE_GRAPH procedures | DBMS_INMEMORY | 07-Oct-2023 |
| DBMS_JSON0 has 11 new objects | DBMS_JSON0 | 24-Jan-2024 |
| DBMS_METADATA_BUILD has new HAS_FILTER function | DBMS_METADATA_BUILD | 01-Apr-2024 |
| DBMS_MLE has 10 new objects | DBMS_MLE | 06-May-2023 |
| DBMS_OPTIM_BUNDLE has new SET_FIX_CONTROLS procedure | DBMS_OPTIM_BUNDLE | 01-May-2023 |
DBMS_PQDIAG has new qqcslv_info_prejoin and qqcslv_info_postjoin functions |
DBMS_PQDIAG | 01-May-2023 |
DBMS_PSWMG_IMPORT has new IMPORT_HISTORY_INSERT procedure |
DBMS_PSWMG_IMPORT | 24-Aug-2023 |
| DBMS_RCVCAT has 15 new objects | DBMS_RCVCAT | 07-Jul-2023 |
| DBMS_RCVMAN has 14 new objects | DBMS_RCVMAN | 04-Jul-2023 |
| DBMS_RCVVPC removed the G_RAREP_USER function added in 21c | DBMS_RCVVPC | 27-Jun-2023 |
| DBMS_REPLAYHUB has 3 new subprograms | DBMS_REPLAYHUB | 01-Mar-2024 |
| DBMS_SODA_DML has new DO_UPDATE_DESCRIPTOR subprogram | DBMS_SODA_DML | 27-Mar-2024 |
| DBMS_SODA_USER_DML has new CREATE_USER_INNER procedure | DBMS_SODA_USER_DML | 01-Apr-2024 |
| DBMS_SODA_UTIL has 6 new subprograms | DBMS_SODA_UTIL | 08-Apr-2024 |
| DBMS_SQLCONTROL_INTERNAL dropped EXISTS_OBJECT added OBJECT_EXISTS | DBMS_SQLCONTROL_INTERNAL | 01-Dec-2023 |
| DBMS_SQLSET has new DROP_SQLSET_BY_PREFIX procedure | DBMS_SQLSET | 08-Jun-2023 |
| DBMS_SWAT_INTERNAL has 6 new subprograms | DBMS_SWAT_INTERNAL | 18-Dec-2023 |
| DBMS_SYS_MLE has 11 new subprograms | DBMS_SYS_MLE | 01-Dec-2023 |
| DBMS_TEQK has 4 new subprograms | DBMS_TEQK | 08-Dec-2023 |
| DBMS_USER_CERTS has new ADD and DROP _CERTIFICATE_REPL procedures | DBMS_USER_CERTS | 06-Jun-2023 |
| DBMS_UTILITY has new GET_COLUMN_LIMIT function | DBMS_UTILITY | 06-Jun-2023 |
| DBMS_XMLDOM_ICD has all 6 subprograms removed and is now an orphaned header | DBMS_XMLDOM_ICD | 24-Aug-2023 |
| DBMS_XSTREAM_ADM_INTERNAL dropped ADD and UPDATE GOLDENGATE_PRIVILEGE | DBMS_XSTREAM_ADM_INTERNAL | 14-Apr-2024 |
| DBMS_XSTREAM_AUTH_IVK dropped all 3 GRANT_ADMIN procedures | DBMS_XSTREAM_AUTH_IVK | 29-Apr-2024 |
| DIANA has 10 new subobjects | DIANA | 14-Apr-2024 |
| DMP_SYS has new UPDATE_VIEWS procedure | DMP_SYS | 30-Mar-2024 |
| GENDATAPROVIDERINTERFACE has new CLOSE subrogram | GENDATAPROVIDERINTERFACE | 27-Mar-2024 |
| HTMLDB_UTIL has 23 new subprograms | HTMLDB_UTIL | 14-Apr-2024 |
| JAVAVM_SYS has the procedure UNINSTALL_DBHADOOP removed | JAVAVM_SYS | 07-Aug-2023 |
| JAVAVM_SYS has the procedure JPM_ROOT_ENABLED added | JAVAVM_SYS | 18-Apr-2024 |
| JVMRJBCINV has the function SET_MODULE_NAME added | JVMRJBCINV | 18-Apr-2024 |
| KU$_DPLOAD removed all previously existing subobjects and added 6 new ones | KU$_DPLOAD | 01-Apr-2023 |
| KU$_DPLOCK has new GET_DB_VERSION function | KU$_DPLOCK | 07-Aug-2023 |
| LOGSTDBY_INTERNAL dropped 6 subprograms with names beginning with EDS | LOGSTDBY_INTERNAL | 14-Dec-2023 |
| OPG_GRAPHOP has new POPULATE_DISTINCT_VERTEX_TAB procedure | OPG_GRAPHOP | 16-Feb-2024 |
| OWM_ASSERT_PKG dropped NOOP procedure | OWM_ASSERT_PKG | 27-Mar-2024 |
| OWM_ASSERT_PKG has new VERIFYOVMSQL procedure | OWM_ASSERT_PKG | 27-Mar-2024 |
| PRIVATE_JDBC has new GET_MAX_STRING_SIZE function | PRIVATE_JDBC | 20-Aug-2023 |
| PRIVATE_JDBC_DR has new GET_MAX_STRING_SIZE function | PRIVATE_JDBC_DR | 01-Aug-2023 |
| PRVT_ASH_OMX has new FIND_ASH_TIMEZONE function | PRVT_ASH_OMX | 02-Sep-2023 |
| PRVT_COMPRESS dropped LOAD_TAB_INMEMORY procedure | PRVT_COMPRESS | 27-Jan-2024 |
| PRVT_COMPRESS added 5 new subprograms | PRVT_COMPRESS | 27-Jan-2024 |
| SDO_RDF_SYS has new PRIVS_FOR_OLS_LBACSYS procedure | SDO_RDF_SYS | 04-Aug-2023 |
| UTL_RECOMP has new 3 new objects relocated from UTL_RECOMP2 in 21c | UTL_RECOMP | 10-Jun-2023 |
| Built-in Packages with New or Removed Overloads | ||
| DBMS_ABDTASK_ADMIN.MODIFY_ABDTASK_SETTINGS 1 has new overload | DBMS_ABDTASK_ADMIN | 01-May-2023 |
| DBMS_ADDM has 4 new subobjects and FAILED_AUTO_TASKS_REPORT is removed | DBMS_ADDM | 05-May-2023 |
| DBMS_CLOUD CREATE_CREDENTIAL and.SEND_REQUEST have 1 new overload each | DBMS_CLOUD | 17-Dec-2023 |
| DBMS_CLOUD_INTERNAL.CREATE_CREDENTIAL has 2 new overloads | DBMS_CLOUD_INTERNAL | 17-Dec-2023 |
| DBMS_GOLDENGATE_ADM_INT_INVOK has 2 new overloads | DBMS_GOLDENGATE_ADM_INT_INVOK | 18-Feb-2024 |
| DBMS_MLE has 14 new overloads | DBMS_MLE | 06-May-2023 |
| DBMS_SQLSET.UPDATE_SQL_SET has 1 new overload | DBMS_SQLSET | 08-Jun-2023 |
| DBMS_SYS_SQL has 26 new overloads | DBMS_SYS_ERROR | 30-Mar-2024 |
| DBMS_SYS_SQL has 16 new overloads | DBMS_SYS_SQL | 08-Dec-2023 |
| KUPD$DATA_INT.SEND_TRACE_MSG has a new overload 2 | KUPD$DATA_INT | 01-Apr-2024 |
| KUPM$MCP.FILE_LOG_MESSAGE has a new overload created as Overload 1 | KUPM$MCP | 14-Feb-2024 |
| Built-in Packages with Parameters Changes | ||
| DBMS_AVTUNE many objects have parameters and data type changes | DBMS_AVTUNE | 01-May-2023 |
| DBMS_AWRHUB.SETUP_SERVER_CACHE_MAILBOX dropped 1 parameter | DBMS_AWRHUB | 05-May-2023 |
| DBMS_AWRHUB.SETUP_SOURCE_CACHE_MAILBOX added 1 new parameter | DBMS_AWRHUB | 05-May-2023 |
| DBMS_AWRHUB_SOURCE.MODIFY_SOURCE_SETTINGS has 4 new parameters | DBMS_AWRHUB_SOURCE | 05-May-2023 |
| DBMS_BLOCKCHAIN_TABLE.GET_BYTES_FOR_ROW_HASH has new parameter | DBMS_BLOCKCHAIN_TABLE | 01-May-2023 |
| DBMS_BLOCKCHAIN_TABLE.GET_SIGNED_BLOCKCHAIN_DIGEST has 2 new parameters | DBMS_BLOCKCHAIN_TABLE | 01-May-2023 |
| DBMS_BLOCKCHAIN_TABLE.IMPORT_CHAIN has 2 new parameters | DBMS_BLOCKCHAIN_TABLE | 01-May-2023 |
| DBMS_BLOCKCHAIN_TABLE.IMPORT_EPOCH has 3 new parameters | DBMS_BLOCKCHAIN_TABLE | 01-May-2023 |
| DBMS_BLOCKCHAIN_TABLE.SIGN_ROW has new parameter | DBMS_BLOCKCHAIN_TABLE | 01-May-2023 |
| DBMS_CLOUD has new SEND_REQUEST parameters | DBMS_CLOUD | 17-Dec-2023 |
| DBMS_CLOUD_INTERNAL has 2 objects with new parameters | DBMS_CLOUD_INTERNAL | 17-Dec-2023 |
| DBMS_GSM_FIXED.FIXBC has 2 new parameters | DBMS_GSM_FIXED | 08-Apr-2024 |
| DBMS_GSM_SEC.PUTMKEY has a new parameters | DBMS_GSM_SEC | 28-May-2023 |
| DBMS_PDB_ALTER_SHARING has a new FORCE parameter in 5 objects | DBMS_PDB_ALTER_SHARING | 06-Jun-2023 |
| DBMS_REPLAYHUB has 4 objects with new and/or renamed parameters | DBMS_REPLAYHUB | 01-Mar-2024 |
| DBMS_USER_CERTS has 2 objects with renamed parameters | DBMS_USER_CERTS | 06-Jun-2023 |
| Built-in Packages with New or Removed Constants, Exceptions, Types, or other Significant Changes | ||
| DBMS_AVTUNE has new constants and types | DBMS_AVTUNE | 01-May-2023 |
| DBMS_BLOCKCHAIN_TABLE pragma has changed from UNSUPPORTED to NONE | DBMS_BLOCKCHAIN_TABLE | 01-May-2023 |
| DBMS_CLOUD has many new constants | DBMS_CLOUD | 01-May-2023 |
| DBMS_DB_VERSION has new 23c constant | DBMS_DB_VERSION | 22-Apr-2024 |
| DBMS_EDITIONS_UTILITIES has 4 new constants | DBMS_EDITIONS_UTILITIES | 10-Jun-2023 |
| DBMS_GSM_DDL.DECDDLVCH trim size parameter has new default value | DBMS_GSM_DDL | 28-May-2023 |
| DBMS_GSM_FIXED has new ALL_DATABASES and IN_PAYLOAD constants | DBMS_GSM_FIXED | 08-Apr-2024 |
DBMS_PQDIAG has new qcslv_type_postjoin and qcslv_col_postjoin types |
DBMS_PQDIAG | 01-May-2023 |
| UTL_RECOMP has new ORACLE_MAINTAINED and STUBS constants | UTL_RECOMP | 10-Jun-2023 |
| Related Topics |
|---|
| New in 11.2 |
| New in 12.1 |
| New in 12.2 |
| New in 18c |
| New in 19c |
| New in 20c |
| New in 21c |
| This site is maintained by Daniel Morgan. Last Updated: | This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved | ||||||||
|
|
|||||||||