All the different ways to generate DDL for your tables, views, and other Oracle Database objects in Oracle SQL Developer Web, also known as Database Actions.
How to take your personal NETFLIX streaming data and import it to Oracle Database, then use SQL to find out how much time we’ve wasted.
A deeper look at our Spotify streaming data that we’ve imported into our Oracle Database. Here I share a few interesting SQL queries and explain how they work.
Importing your personal data from Spotify to a database for learning SQL can be done in just a few clicks with Oracle’s Always Free Autonomous Database!
Troubleshooting guide for starting up Oracle REST Data Services and invalid connection pools. Bad passwords, user accounts, and more.
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!
2022 review – A look back on what happened with me in 2022 and what might be happening in 2023 with thatjeffsmith (or, just Jeff).
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.
Oracle SQLcl and Oracle REST Data Services (ORDS) versions 22.4 are now available for download! New command in SQLcl: ‘argument’
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 enable REST API debug messages for your ORDS endpoints in Oracle Autonomous Database – just use ORDS_ADMIN.SET_PROPERTY() !