π‘ A hands-on demo showcasing how to manage Oracle Database projects using SQLcl, GitHub, and automation best practices.
This demo simulates a full DevOps workflow around a sample HR database application. Youβll learn how to:
- β Initialize a SQLcl project
- π Track and manage database changes
- π¦ Generate deployable artifacts
- π Automate deployments using GitHub
Ideal for DBAs, developers, and DevOps engineers exploring Oracle database automation.
Oracle SQLcl supports a powerful feature called Projects, which enables:
- π Structured folder layout for source control
- π§© Custom filters for object selection
- π§Ύ Liquibase-compatible changelogs
- π οΈ Integration with build pipelines
π Learn more in the Oracle SQLcl documentation.
Estimated setup time: 5 minutes
- Oracle SQLcl installed and accessible from your shell
- GitHub CLI (
gh
) installed and authenticated - Oracle Autonomous DB (or any accessible Oracle DB)
- SQL*Net Wallet access (if using Autonomous)
- Clone this repository
git clone https://github.com/YOUR_USERNAME/YOUR_REPO.git cd YOUR_REPO