Enjoyed Maria’s post on comparing pending vs current stats for your tables in an Oracle Database? Well here’s a REST API to do the same thing!
Inserting data to your Oracle Database that includes multi-line strings, including blank lines? You may want to look at SET SQLBLANKLINES.
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.