Posts

Guide to APEX Working Copies & Merging

Image
  1. Introduction: Why Working Copies? Start with the "Why." Before this feature, developers often exported/imported applications with different IDs or—worse—edited the same page at the same time. The Problem: Merge conflicts, overwritten code, and "Development Freezes." The Solution: Working Copies allow for isolated development environments within the same Application ID.         In Oracle APEX, this is handled through two actions: Merge into Main Refresh Working Copy           How to Merge     Steps: Open your Working Copy. Click on the Working Copy menu. Select Merge into Main. Review the list of changed components. Confirm merge.      You will see:   Changed components   Newly added components   Deleted components   This is where you must be careful.    Selecting Impacted or Changed Components    The merge screen does not force you to merge everything.   ...
Post a Comment
Read more

Oracle APEX Tutorial: Excel Downloads with Multiple Sheets

Image
When I started working on these requirements, I encountered some challenges. However, through my own research and development, I was able to successfully complete this. If you have any questions, please feel free to ask them here. I'm more than happy to provide further details or clarifications. Check out on LinkedIn https://in.linkedin.com/in/venkatraman-s-63385719b Step 1 :  Create Package with a procedure, Sample Template :  create or replace PROCEDURE generate_excel_file (     p_excel_blob OUT BLOB ) IS     l_excel_data CLOB; -- Replace with actual XML content for the Excel file BEGIN     -- Generate Excel XML content (replace with actual XML creation logic)     l_excel_data := '<?xml version="1.0"?>         <?mso-application progid="Excel.Sheet"?>         <Workbook xmlns="urn:schemas-microsoft-com:of...
Post a Comment
Location: Chennai, Tamil Nadu, India
Read more