Skip to Main Content
Feature Request FR-4392
Product Area Developer Experience
Status CLOSED

2 Voters

Easy the process for JS files conversion to .sql and export

ankit.bhatt2 Public · Apr 7 2025

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.
This is a great idea! You can already achieve this in APEX today with a slightly different approach.

Comments

Comments

  • greg.jarmiolowski APEX Team OP 2 months ago

    You can export static application files with the “Component Export” feature.

    Click Export and then when you get to the application selection page there is a set of tabs near the top of the page. Click “Components” and then filter for Component Type = Application Static File.

    You can also sort and filter on the last updated column.

    Select the files you want and then click Add to Export button and follow the rest of the wizard steps.