Instead of doing my normal ‘most popular posts’ review from the past year, this time around I wanted to share the posts that I had the most fun putting together. Consider these ‘hidden gems’ or interesting items that may have missed your radar the first time around.
My ‘popular’ posts where around product updates and releases, if you’re interested in finding those, just use ye olde search bar.
I show how to download your Netflix subscriber data, and use SQL to answer fun questions.
ORDS won’t start, won’t work – how do I fix it?
Can I create a module, template, and handler all in one go? Yes, yes you can!
Point and click your way through doing a data pump IMPORT task in SQL Developer Web.
Maybe you don’t want all of your employees, maybe you want to filter them, here’s some practical, compound examples.
Did you know you can use the Liqubase DIFF command in SQLcl? Well, now you know.
The biggest new feature in Database 23c comes with REST API support via ORDS.
How to get a SQL prompt in your browser for any Oracle (or MySQL) database in the Oracle Cloud console.
Just hit TAB to get help with your SQL code, at the command prompt using SQLcl.
We updated all of the sample schemas, here’s a look at getting started with SH.
Yes, you can use REST APIs to update your REST APIs.
You can now do partial updates via PATCH!
Easier to read, deal with error messages, and yes, you can still default to plain ole text/json responses vs HTML.
Can you SHOW ME what my JSON docs look like? Yes, yes I can.
Using cURL or Python program to batch load data to your database tables via REST APIs. Since I’m a n00b when it comes to Python, this one took me awhile.
This could turn out to be a HUGE thing for our Oracle Database developers and customers. What do you think?
Your REST API returns data via a PL/SQL stored procedure, here’s how to page the results.
You want to grab specific items from your collection using a REST API with a list of values, here’s how to do it.
Where I asked ChatGPT to build me a REST API to do that plsql refcursor paging stuff. Did it work? Kinda.