New Features 23c: GROUP BY with Aliases/Position Number

As new features within Oracle Database 23c, we can use aliases names and/or position number within the clause GROUP BY.

Group by: Aliases names

Group by : Position Number

Before using position number within group by clause, we need to enable this feature within the session Level.

Enjoy theses features with 23c

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.