After presenting "Oracle's SQLcl CI/CD bombshell" at KSCOPE25, I'm excited about where we are in Oracle CI/CD development. The response was fantastic, and it's evident we are at a breakthrough moment. You can view my presentation and live demo videos...
Building on the previous topic of leveraging Liquibase properties to modify APEX installations, we will delve into a companion technique. This one enables users to define as many property files as they wish in the artifact to set it when deploying. T...
A common question we get: why doesn’t SQLcl Projects support Liquibase rollback? At first glance, Liquibase’s rollback feature seems like a great safety net. Not only can it evolve your schema forward, it promises to take you backward if something go...
Why Developers Struggle Between ORMs and Raw SQL As developers, we often find ourselves torn between using Object-Relational Mappers (ORMs) and writing raw SQL queries. Each approach has its advantages and trade-offs. sqlc, however, offers a unique s...
When working with applications based on Oracle Database (like APEX), ensuring the quality of your PL/SQL code is essential. But how can you quickly check for issues? The answer is the SQLcl CODESCAN. A FREE tool that scans your database objects for c...
Prereqs Latest SQLcl Existing SQLcl Project with an APEX app Note On average, I prefer to keep the same Schema name, APEX Application ID, Workspace Name, and Workspace ID across environments and have separate databases. I understand that this isn...
The Question Someone recently asked me: What's the possibility/risk of just using one dev branch and multiple developers working in there, then just merge to main when a release/artifact is generated? Good Practice? Bad Practice? Thoughts? Risky Bu...
This is a Quick Reference / Cheat Sheet take your pick. SQLcl Projects is a feature in Oracle's SQLcl tool that helps manage and automate database changes and deployments for Oracle Database and APEX applications. It provides a structured approach to...
Keeping your development tools up to date is essential for smooth collaboration and to take advantage of the latest features and fixes. When working with SQLcl Projects, upgrading SQLcl requires a structured approach to minimize disruption and ensure...
If you’re reading this, you were just as excited as I was to see SQLcl release 24.3 and its Database Application CI/CD tooling from Oracle. After the announcements, the posts on getting started by Dan McGhan [An Overview of the Oracle SQLcl Projects ...
