I have a schema called dev_env, and I've built all my Oracle APEX applications in it, using a separate parsing schema for each application — for example, sales for the sales app, and the same for finance.
I want to use a CI/CD approach to move from dev to stage to production. Currently, I only use APEX export via SQLcl, but I also want to automatically sync schema DDL and functions/procedures — managing my schema manually has become very difficult, and I want to automate the entire process. Suggest me...