Time to do the downloading!
Let’s do a quick overview of what you have to look forward to…and as always, we’ll do deep dives on features over the next few days and weeks.
This release is mostly bug fixes, but there are few new things to look forward to.
Getting the execution plan and stats of a query…without having to scroll through all the query results.
So, I don’t need to look at the 107 rows, I can just look at the performance information. If you like this, tip your friendly @oraclebase, he asked for it 🙂
The other new feature is the ability to additionally generate SQL scripts when using the Liquibase (lb) command for generating changeLogs on a schema.
There’s a -sql flag you can take advantage of.
This will make your DIFFs much easier to parse with your human eyes, and again, was requested by MANY of our SQLcl community, so thanks for that feedbac!
And remember..you can download these directly now, no clicking through EULAs or signing in with your Oracle SSO! For ORDS, you can get these via Yum (SQLcl is coming soon as well).
SQL Developer Web / Database Actions
From charts…we now have dashboards!
Again, many more details to follow, but one important thing, that also follows over to REST Development. Charts and REST APIs will require you to explicitly say you want your endpoints UNPROTECTED.
So basically, no more accidentally forgetting to secure a REST API.
This feature, Charts (which includes dashboards), will be included in the Autonomous Shared services in the Oracle Cloud.
Required, must select a privilege or must explicitly say ‘Not Protected’ before creating your Chart.
Speaking of REST…
Better support for Implicit and Explicit Parameters in your Handler code blocks is now here:
And ORDS itself…?
Just bug fixes for the most part. 21.4 will be a quick release cycle so again won’t be much in way of new features. But, 22.1 on the other hand will see lots of fundamental changes…around Java, our installer, and more. Stay tuned for an updated Statement of Direction for ORDS and all of our DBTools.
For SQLcl, I guess I can tease we’re building Data Pump and Data Guard commands.