Skip to main content

Exporting Multiple APEX Applications in a Single ZIP File as an End User

This PL/SQL block allows end users to export multiple Oracle APEX applications simultaneously. It collects the selected application IDs, generates their export files, and packages them into a single downloadable ZIP file for convenience.

Step1: Create Classic Report with following query 

SELECT 

APEX_ITEM.CHECKBOX2(1, APPLICATION_ID, p_attributes => 'class="my_value"') AS SELECT_BOX,

    OWNER,

    WORKSPACE,

    APPLICATION_ID,

    APPLICATION_NAME,

    CREATED_BY,

    CREATED_ON,

    LAST_UPDATED_BY,

    LAST_UPDATED_ON

FROM APEX_APPLICATIONS;

Step2: Create Following Apex Page Items

Step3: Paste the following code in Function global declaration

$(document).ready(function () {

    $('.my_value').on('click', function () {

        var app_id = "";

        $('.my_value:checked').each(function () {

            app_id += $(this).val() + ",";     

        });

        app_id = app_id.substring(0, app_id.length - 1);

        $s('P4_SEL_APP_ID', app_id);

    });

});

When a checkbox is clicked in the report, the application IDs from the selected rows are stored in a page item as a comma-separated list.

Step 4: Paste the following PL/SQL code into a page process and configure it to run on button click.

declare

    l_files       apex_t_export_files;

    l_all_files   apex_t_export_files := apex_t_export_files();

    l_zip         blob;

    l_export      apex_data_export.t_export;

    l_original_id boolean := (:P4_ORIGIONAL_ID = 'Y');

    l_app_ids     apex_t_varchar2;

begin

    l_app_ids := apex_string.split(:P4_SEL_APP_ID, ',');

    for i in 1 .. l_app_ids.count loop

        l_files := apex_export.get_application(

                       p_application_id     => l_app_ids(i),

                       p_with_original_ids  => l_original_id,

                       p_with_date          => true,

                       p_with_comments      => true

                   );

        l_all_files := l_all_files multiset union all l_files;

    end loop;


    if l_app_ids.count > 1 or :P4_ZIPFILE = 'Y' then

        l_zip := apex_export.zip(p_source_files => l_all_files);

        l_export.content_blob := l_zip;

        l_export.mime_type    := 'application/zip';

        l_export.file_name    := case 

                                     when l_app_ids.count > 1 then 'apps_export.zip'

                                     else 'f' || l_app_ids(1) || '.zip'

                                 end;

        l_export.format       := 'zip';

        l_export.as_clob      := false;

    else

        l_export.content_clob := l_all_files(1).contents;

        l_export.mime_type    := 'text/plain';

        l_export.file_name    := 'f' || l_app_ids(1) || '.sql';

        l_export.format       := 'sql';

        l_export.as_clob      := true;

    end if;

    apex_data_export.download(p_export => l_export);

end;

Step5 : Save and Run the application.






Comments

Post a Comment

Popular posts from this blog

Reusable JS Functions for Field Validation in Oracle APEX Forms

 These reusable JavaScript functions provide client-side validation for Oracle APEX forms, improving data accuracy before submission. They allow developers to enforce mandatory fields and ensure certain fields contain only numeric values . By using these functions, APEX forms become more user-friendly and robust , reducing the chance of invalid data entry. Step 1: Create a Static Content region on the Global Page using the Blank with Attributes template. Step 2: Paste the following code into the HTML Source section of the region. <script>     function validateInputField(inputFieldId, pageItemName, errorMessage) {         $(inputFieldId).focusout(function() {             var itemValue = apex.item(pageItemName).getValue();             apex.message.clearErrors(pageItemName);             if (!itemValue) {               ...
Post a Comment
Read more

Reusable JavaScript Function to Highlight Holidays on APEX Date Picker Item

Date pickers are an essential part of web applications, especially when users need to select dates for bookings, reports, or scheduling tasks. However, in many business scenarios, certain dates like holidays, weekends, or special events need to be visually distinguished to prevent users from selecting them by mistake. In this blog, we will create a reusable JavaScript function that highlights holiday dates in an Oracle APEX date picker. This approach allows developers to call the function anywhere in their application, ensuring consistency and reducing redundant code. By the end, you’ll have a flexible solution to visually mark holidays on any date picker item in your APEX applications. Step 1: Create a Static Content region and set it to Blank with Content under the region attributes. Step 2: Inside that region, enclose a <script> tag and paste the following JavaScript function. function applyHolidayFormatterToDateItems(itemNames) {   const holidayList = [   ...
Post a Comment
Read more

Customizing Classic Card Report Template with Collapse Option in Oracle APEX

 This customization adds collapse/expand controls to a Classic Card Report in Oracle APEX, enhancing user interaction and report usability. Step 1: Copy the existing Classic Report Card template and save it with a new name. Step 2: Add the following customized code in the Row Template 2 section. <li class="t-Cards-item #CARD_MODIFIERS#">   <div class="t-Card">     <!-- Icon and Title/Subtitle -->     <a href="javascript:void(0);" class="t-Card-wrap">       <div class="t-Card-icon u-color #CARD_COLOR#">         <span class="t-Icon fa #CARD_ICON#">           <span class="t-Card-initials" role="presentation">#CARD_INITIALS#</span>         </span>       </div>       <div class="t-Card-titleWrap">         <h3 class="t-Card-title">#CARD_TITLE#</h3> ...
Post a Comment
Read more