My Oracle Support Banner

23ai New Feature - Aggregation over INTERVAL Data Types (Doc ID 3002656.1)

Last updated on JULY 20, 2024

Applies to:

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

Goal

With Oracle Database 23ai, the aggregation capabilities of the INTERVAL data type have been expanded to support summation, averaging, and analytical functions.
As a result, the INTERVAL data type can now be utilized in aggregation processes using the GROUP BY clause, making its use in databases more convenient.

This document has a use case example of the new 23ai feature "Aggregation over INTERVAL Data Types".

For more details, see document:

Oracle Database Release 23
Oracle Database New Features

2 Application Development

Aggregation over INTERVAL Data Types

https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/application-development.html#GUID-CE5F8EED-934D-458D-B81C-6C8D617F31A2

 

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.