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.
January
How much time did my daughter waste watching Grey’s Anatomy?
I show how to download your Netflix subscriber data, and use SQL to answer fun questions.
Troubleshooting ORDS startup errors, ‘the pool is invalid’
ORDS won’t start, won’t work – how do I fix it?
Creating an ORDS REST API in a single call
Can I create a module, template, and handler all in one go? Yes, yes you can!
February
Data Pump and SQL Developer Web, importing in Autonomous
Point and click your way through doing a data pump IMPORT task in SQL Developer Web.
March
REST APIs and Query Parameter examples using EMPLOYEES
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.
April
JSON Relational Duality View AutoREST APIs
The biggest new feature in Database 23c comes with REST API support via ORDS.
May
SQL Worksheet for any database in the Oracle Cloud
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.
Getting started with our updated SALES_HISTORY (SH) sample schema
We updated all of the sample schemas, here’s a look at getting started with SH.
June
REST APIs to manage your REST APIs
Yes, you can use REST APIs to update your REST APIs.
July
Adding PATCH support for JSON Relational Duality View 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.
August
Can you SHOW ME what my JSON docs look like? Yes, yes I can.
September
cURL vs Python: loading data from a file via Oracle REST API
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.
October
This could turn out to be a HUGE thing for our Oracle Database developers and customers. What do you think?
JavaScript in the Database Presentation
23c and the Multilingual Engine (MLE) for JavaScript, some slides for you to chew on.
November
Paging results of your REFCursors from your REST APIs
Your REST API returns data via a PL/SQL stored procedure, here’s how to page the results.
Query Parameter values to a SQL WHERE IN (:list) in your REST APIs
You want to grab specific items from your collection using a REST API with a list of values, here’s how to do it.
December
Using JavaScript to create test data in 23c Database
Using the FAKER JavaScript library to generate fake EMPLOYEE records, and inserting a 1,000 new records in a single go.
Can AI generate Oracle REST APIs?
Where I asked ChatGPT to build me a REST API to do that plsql refcursor paging stuff. Did it work? Kinda.
