Idea Summary
In Oracle APEX, developers often update JavaScript files during application development. However, exporting these individual files as .sql
scripts (for version control or deployment purposes) currently requires exporting the entire application, which is time-consuming and not developer-friendly.
This idea proposes adding a direct option within APEX Builder to export modified JavaScript files (Inline or File URLs) as .sql
scripts — either via a right-click option or through the shared components > static files section. This would streamline the workflow for developers who wish to version control or deploy only frontend assets, without exporting the entire application structure.
Use Case
- When working in large applications, developers may only change JS files and not touch any other components.
- For better integration with CI/CD pipelines or GIT version control systems, developers often need individual
.sql
exports.
- Speeds up deployment cycles by avoiding full app export for minor UI/front-end changes.
- Useful in collaborative teams where frontend and backend are developed and deployed independently.
Preferred Solution (Optional)
- Add an "Export to SQL" button next to each JavaScript file in Shared Components > Static Application Files.
- Include a "Modified Since" filter to export only the recently changed files.
- Allow exporting through the APEXExport CLI tool or REST API for automation support.