Oracle REST Data Services (ORDS) comes with a PL/SQL API you can use to quickly publish a TEST module, aka ‘Hello, World!’
Turning on or off storage properties for your Oracle Database objects in your SQLcl Liquibase changeSets. Don’t want the tablespace? Use the ‘set ddl’ command!
How to run Liquibase updates for a specific schema with Oracle SQLcl. Log in as one user, deploy changeSets to another with your favorite Oracle Database cli.
JSON, XML, YAML Liquibase changeSets – you can run those in Oracle SQLcl and here are some examples! Create a table, add columns, and insert rows.
Database Tools Tips & Tricks from Oracle Cloud World 2022. YouTube recording of my 30 minute presentation on SQL Developer, ORDS, and SQLcl.
Tuning REST APIs for Oracle Database often comes down to tuning the SQL that powers them. Here’s some advice and an example of how that could be done.
How to create a database in less than 5 minutes, create a table, then batch loading CSV to Oracle – using only REST APIs!
Downloading files in Oracle is easy when you’re using Oracle REST Data Services to build REST APIs. Here’s an example for downloading them by name.
