Hi All,
I am working on an Oracle APEX application and I want to maintain my application in GitHub using a proper source control structure.
Currently, I have database objects in my APEX workspace such as:
- Tables
- Indexes
- Constraints
- Sequences
- Procedures
- Functions
- Packages
- Triggers
I would like to export each database object type as a separate SQL file, for example:
database
|
├── ddl
│ └── tables_indexes_constraints.sql
|
├── procedures
│ └── procedures.sql
|
├── functions
│ └── functions.sql
|
├── packages
│ ├── pkg_name.pks
│ └── pkg_name.pkb
I have already created installation scripts under Application → Supporting Objects in APEX, but I am looking for a way to export/download these scripts as individual files instead of manually copying each script.
Is there any built-in feature in Oracle APEX, SQLcl, or another Oracle-supported tool to export workspace database objects into separate SQL files?
Thanks in advance.