Oracle Database 23.9 Free multi-platform images are now available on container registries docker.io/gvenzl/oracle-free and ghcr.io/gvenzl/oracle-free. With this release, 23.7 images have now gone into Unsupported. See the support matrix for more information.
What’s in Oracle Database 23.9 Free?
As to what new features came in 23.9, you can check out the Oracle Database New Features Guide documentation. This release introduces three of my favorite features, which I was directly responsible for. Naturally, you will see a few blog posts going live in the next few weeks, taking a deep dive into each of them:
GROUP BY ALL– the convenientGROUP BY ALLfunctionality makes ad-hoc queries and data analysis easier than ever before- UUIDv4 support – the popular UUID version 4 supported by most modern programming languages can now also be generated inside the database
- Non-positional INSERT – often referred to by me as
INSERT INTO ... SETclause, this finally provides self-documenting INSERT statements and a lot more
Other favorites of mine: