Oracle APEX Application that relies on Excel Workbook Macro to perform certain functions. This combined application must then run in Oracle cloud, so that users can access it.
I am new to Oracle, and would greatly appreciate help with:
(a) with a pl/sql procedure that selects columns from the two data tables,
(b) put them in one .xlsx file in a directory,
(c) open .xlsm separate workbook that auto execute the macro and
(d) store the processed data back in new data tables in APEX application for interactive reports and dashboard display?