As many readers will be aware, we introduced a cool new JSON datatype in 21c which offers more features and better performance for JSON related features.
Of course, whilst a new datatype is all well and good for 21c, many of us are not planning on moving to 21c because 19c is the long term support release, and so the intention will be to stay on 19c until the next long term support release comes out.
Alas for 19c, there is no such datatype.
But here’s a little tip for those of you that are running on Autonomous Database. Even if you are on 19c, then even though the entire suite of 21c JSON-related features are not available, you can still get the benefits of the new and improved JSON storage by simply modifying the DDL you use to create your JSON segments.
Note that this is only supported on Autonomous, and if you are on the Autonomous JSON database, this is automatically taken care of.