DOAG 2025: Optimize the CI/CD process with SQLcl and GitLab pipelines

DOAG 2025

With the release of version 24.3 of SQLcl, Oracle has introduced a new feature that supports automated Continuous Integration and Continuous Delivery (CI/CD). The Liquibase extension, integrated since SQLcl version 19.2, has already allowed developers to deploy database structures as well as SQL and…

Optimizing URL Generation with APEX_UTIL.prepare_url: A Reliable URL Strategy for Oracle APEX

When working with Oracle APEX, the syntax of generating links via APEX_UTIL.prepare_url is dependent on the app session and whether Friendly URLs are enabled or not. Based on the session context, the function will generate absolute or relative URLs. These differences become apparent, for…