My Oracle Support Banner

23c New Feature - Table Value Constructor (Doc ID 3002378.1)

Last updated on FEBRUARY 28, 2024

Applies to:

Oracle Database - Enterprise Edition - Version Beta 23c and later
Oracle Database - Standard Edition - Version Beta 23c and later
Information in this document applies to any platform.

Goal

Oracle Database supports that multiple rows be specified in the VALUES clause from 23c.
Operations that were performed in multiple SQL before 21c can be performed in one SQL in 23c.

This document has a use case example of the new 23c feature "Table Value Constructor".


For more details, see document:

Oracle Database Release 23
Oracle Database New Features
2 Application Development
Table Value Constructor
https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/application-development.html#GUID-DDB05DA1-42A8-4241-B22A-64AD2F46B90A

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.