Oracle SQL Developer’s extension for VS Code version 24.1.1 is now available! Export directly to the clipboard, or toggle your plsql spec/body!
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)
In Oracle, how to use SQL to pull a distinct list of values from a JSON column. Hint: use JSON_TABLE.
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.
Here’s a roundup of our big Oracle Database 23ai news, including Larry & Juan’s video, and our updated VirtualBox appliance so you can play with 23, too!
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.
How to move your OAuth2 clients from one Oracle Database to another, maintaining their associated Client Secrets – with our PL/SQL API.
You can give yourself an easy visual reminder of what database connection you’re working in, and also make them easier to find 🚀
The recording from our Oracle SQL Developer Extension for VS Code webinar is now available! Plus, here are a few previews of new features about to ship!
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.