How to use JSON_EXISTS function in your Oracle Database REST APIs. Hint: use the PASSING clause! Finding movies having 2 common GENRES (from a JSON array)
A quick look at the interactive installer improvements for Oracle REST Data Services (ORDS) version 24.1 and a reminder to check the logs.
Moving from 19c to 23ai? Dealing with JSON will get much easier! A few notes on migrating data, & updating your REST APIs. Plus a reminder on Duality Views.
My YouTube Channel is still alive, barely! I’ve just uploaded a 20 minute introduction and tutorial for our SQLDev VS Code Extension.
One of the biggest productivity features added to our latest update for Oracle SQL Developer extension for VS Code (24.1) is the ability to FILTER things.
Oracle SQL Developer Extension for VS Code version 24.1 is now available on the VS Code Marketplace! Lots of bug fixes and several big new features.
You can give yourself an easy visual reminder of what database connection you’re working in, and also make them easier to find 🚀
Oracle REST Data Services (ORDS) version 24.1 is now available! Here’s the release recap and summary of major features and changes you can expect.
Oracle SQLcl version 24.1 is now available! Lots of bug fixes, a new command for backgrounding tasks, and HIGHLIGHTING is now on by default.
Hot to build a REST API to update a record in the Oracle Database, using new 23c RETURNING OLD clause – see what the previous and new value are!