/* Mostly about Oracle APEX, ORDS, PL/SQL and a bit of Linux in between */
DOAG 2025: Optimize the CI/CD process with SQLcl and GitLab pipelines
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…
Part 2: Import binary raw data files during APEX App Import
In the previous blog post, we have seen how to export the binary raw data of application and workspace files during an APEX application export. This post will focus on how to import files to APEX during the Application import process. Like described in…
Part 1: Export APEX App with workspace and application files in uncoded binary raw data format
Oracle APEX allows you to export applications including all app components as SQL files. This includes application files which binary raw contents are converted into a hexadecimal string representation. This makes it difficult to add, edit or review files from outside an APEX workspace….
How to reduce Merge Conflicts of exported APEX Apps
When exporting an APEX app by a tool like SQLcl splitted in separated files, each SQL file will include arguments inside the Metadata export which can differ when exporting from different APEX instances. Depending on the amount of generated files, this may cause a…