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.
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!
How to use query filter parameters on your Oracle REST API GET requests to specify exactly which items you want retrieved. No code required!
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.
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.
How to quickly clean up your Oracle Database schemas by removing your data loading error log tables using SQL Developer Web.
Folks in your organization can now request their own database user accounts using our Self Service Schema feature in Oracle SQL Developer Web!
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.
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!