“ORDS and SQLcl 22.4 now available” – some of my favorite words to utter as a product manager!
The actual download links –
We do quarterly releases for our products, and it’s time to end the year with our 22.4 updates! ORDS 22.4 has already been submitted to our Oracle Cloud DevOps team, so you’ll see that show up for Oracle Autonomous Shared subscribers over the next few days as well.
So what’s new?
We have a new command, ARGUMENT.
Do you have SQL scripts that take in one or more inputs? What happens when you forget to supply one? Wouldn’t it be nice if you could code into your scripts either a PROMPT for the user to supply said argument OR supply default(s)?
That’s what we have now. Simply use the ARGUMENT command IN your SQL scripts.
Example: default argument values
Example: prompting for value
Other SQLcl items of note
Bug fixes, lots of them. Some insight/SQL completion bugs were addressed, but the vast majority were fixes for our LIQUIBASE support. Additionally, we updated the Liqubase library from 4.15 to 4.17.
There was a lot of work put into this release that end users/system administrators won’t necessarily see directly. And some more work that WILL BECOME evident later in 2023. That being said, most of what you’re getting in 22.4 are bug fixes.
Pools and routing patterns at start-up
Some previous 404 responses will now result in more accurate 403 and 429s, which hopefully will be much less frustrating for API consumers.
SQL-based APIs and AutoREST Filtering & Sorting
One of my favorite ORDS features, just got a little bit of a boost. You can now SORT your responses, and provide input if you want the NULLs first or last.
So, give me a list of my employees, but sort them on COMMISSION_PCT descending, and put the NULLs on the last pages.
I “lied” about SQL Developer & Data Modeler 22.4
I previously mentioned we would have maintenance updates for these products this quarter. That was our intention and goal, but that’s evolved to 23.1. We’re forecasting those will be made available closer to the end of January.
In March we’ll have SQLcl and ORDS 23.1. And hopefully we’ll also have v1 of “SQL Developer Next!”