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