Oracle AI Database 23.26.1 added partition by expression support
=> you can use an expression directly instead of a column
e.g. by email top-level domains with
PARTITION BY LIST ( REGEXP_SUBSTR ( email_address, '[^.]+$' ) )
@danischnider.bsky.social demos
buff.ly
In the latest version of the Oracle database, it is now possible to define the partition key of a partitioned table using an expression. This was already possible previously, but only with a small …