How to use Oracle SQLcl and the Liquibase DIFF command to compare two schemas in an Oracle Database. This post includes a sample command and report.
You have lots of options for using Data Pump to export your data from Oracle Autonomous Database in the Oracle Cloud (OCI). here’s a quick review!
How to quickly clean up your Oracle Database schemas by removing your data loading error log tables using SQL Developer Web.
Step by step with screenshots, how to setup your Oracle Autonomous Database such that it can do Data Pump imports with SQL Developer Web (AKA Database Actions).
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.
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.
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).