Did you know that SQLcl can generate XML changeSets & equivalent SQL files? What about having a rich editing experience directly in the OCI Console?
If you want to publish REST APIs for your Oracle Database covering multiple schemas’ worth of data, using a central schema with VIEWs might be useful.
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 query filter parameters on your Oracle REST API GET requests to specify exactly which items you want retrieved. No code required!
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!
Quick Q&A, why do my ORDS REST APIs return null vs empty string ” responses? Some SQL and an example, plus what NOT to do.
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).
Folks in your organization can now request their own database user accounts using our Self Service Schema feature in Oracle SQL Developer Web!
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.