Oracle SQLcl version 22.1’s new SQL performance code scanning rules, where they came from, and some examples. Find bad SQL before it hits production!
SQLcl 22.1 is now available and we now support Data Guard commands! Also, we now REQUIRE you to upgrade Java to at least version 11 or 17 – no more 8!
How to use the built-in OpenAPI (Swagger) REST client in Oracle REST Data Services to test your POST endpoints for your Oracle Database REST APIs.
How to cURL Oracle Database Data Pump Export job in your Oracle Autonomous Database, via Oracle REST Data Services (ORDS) – code & screenshots!
Release News: Some updates with bug fixes for ORDS, SQL Developer, and SQL Developer Data Modeler Oracle customers. Quick overview and download links.
How to model templates and write handlers for tables with multiple primary keys for Oracle using REST Data Services (ORDS).
A draft copy of my Best Practices for Database REST APIs…using Oracle REST Data Services (ORDS). Installation, development, and performance.
Passwords expire, change, get lost. Here’s how to update your Oracle Database user passwords in your Oracle Database Tools Cloud Service Connections.
A quick look at generating your own JSON responses in Oracle REST Data Services using a handy PL/SQL package from community member at large Stew Ashton.
Using the Oracle REST Data Services $instr and $like functions for filtering your REST API responses – a few easy examples for REST Modules AND AutoREST enabled tables in Oracle.