New In Oracle Database Versions 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 (Developer Release AKA Beta 2). Expect changes to take place regularly and often. |
||
Architecture | ||
New Background Processes
|
Background Processes | 01-May-2023 |
New Objects
|
ANNOTATIONS DOMAINS & CHECK CONSTRAINTS |
30-Jul-2023 01-May-2023 |
Oracle Machine Learning (OML) | - | - |
?? | - | - |
Security | ||
Read Only Users | USERS | 01-May-2023 |
Object Privileges: Schema Level Object Privileges (We strongly recommend not using this feature) | Object Privileges | 01-May-2023 |
System Privileges | 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 | 01-May-2023 |
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) - type 1 83>97, type 2 237>272, type 3 95>103, type 6 32>38
|
Startup Parameters | - |
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 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 |
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_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_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_HCHECK | DBMS_HCHECK | 01-May-2023 |
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_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 | 08-Jun-2023 |
DBMS_SQL_FIREWALL | DBMS_SQL_FIREWALL | 31-May-2023 |
DBMS_SWAT_XML | DBMS_SWAT_XML | 06-Jun-2023 |
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_ILM_INVOKERS_RIGHTS | PRVT_ILM_INVOKERS_RIGHTS | 07-Jun-2023 |
PRVT_UTILITY | PRVT_UTILITY | 02-May-2023 |
Removed Built-in Packages | ||
BSLN | - | 09-Jun-2023 |
CARTRIDGE | - | 09-Jun-2023 |
CTX_TREE | - | 09-Jun-2023 |
DBMS_EDITIONS_UTILITIES2 | - | 10-Jun-2023 |
DBMS_HS_PARALLEL | - | 15-Jun-2023 |
DBMS_HS_PARALLEL_METADATA | - | 15-Jun-2023 |
DBMS_LIBCACHE | - | 15-Jun-2023 |
DBMS_LIBCACHE$DEF | - | 15-Jun-2023 |
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 |
REDO_DIFF | - | 09-Jun-2023 |
TKHCS_LOG_PKG | - | 09-Jun-2023 |
UTL_RECOMP2 | - | 10-Jun-2023 |
Built-in Packages with New or Removed Objects | ||
DBMS_ADDM has 2 new objects related to failed auto tasks | DBMS_ADDM | 01-May-2023 |
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 | 01-May-2023 |
DBMS_DUMA_INTERNAL has 4 new objects | DBMS_DUMA_INTERNAL | 13-Jun-2023 |
DBMS_FS has new FS_EXISTS and LIST_FILES functions | DBMS_FS | 25-Sep-2023 |
DBMS_GSM_SEC has 8 new objects | DBMS_GSM_SEC | 28-May-2023 |
DBMS_IMMUTABLE_TABLE has new ADD_INTERVAL_PARTITIONING procedure | DBMS_IMMUTABLE_TABLE | 01-May-2023 |
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_SQLSET has new DROP_SQLSET_BY_PREFIX procedure | DBMS_SQLSET | 08-Jun-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 |
JAVAVM_SYS has the procedure UNINSTALL_DBHADOOP removed | JAVAVM_SYS | 07-Aug-2023 |
KU$_DPLOCK has new GET_DB_VERSION function | KU$_DPLOCK | 07-Aug-2023 |
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 |
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.SEND_REQUEST has 1 new overload | DBMS_CLOUD | 01-May-2023 |
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 |
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_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_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 new constants, exceptions and SEND_REQUEST parameters | DBMS_CLOUD | 01-May-2023 |
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_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 Dan Morgan. Last Updated: | This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved | |||||||||
|
||||||||||