oracle-apex-shared-components.hashnode.devHandling JSON in PL/SQL: Complete Guide with ExamplesJSON (JavaScript Object Notation) has become the standard format for data exchange between applications. In modern Oracle environments—especially when working with Oracle APEX, ORDS, and REST APIs—han5d ago·3 min read
oracle-apex-shared-components.hashnode.devPulling Oracle Fusion Data into Oracle APEX – Automated Daily IntegrationIn one of my recent implementations, I worked on a requirement to sync Oracle Fusion data into Oracle APEX on a daily basis. Instead of manual jobs or external schedulers, I used APEX Automation + PL/SQL + Fusion REST APIs to make the process fully a...Jan 24·2 min read
automated-oracle-apex-backup.hashnode.devAutomated Oracle APEX Backup and Upload to Object StorageAs Oracle APEX developers, we all know how important regular backups are.Manually exporting applications every time is risky and time-consuming. So I decided to automate the complete backup process using Oracle APEX Automation, PL/SQL, and Oracle Obj...Jan 13·3 min read
oracle-apex-shared-components.hashnode.devAutomated Oracle APEX Backup and Upload to Object StorageAs Oracle APEX developers, we all know how important regular backups are.Manually exporting applications every time is risky and time-consuming. So I decided to automate the complete backup process using Oracle APEX Automation, PL/SQL, and Oracle Obj...Jan 13·3 min read
apex-collection.hashnode.devThe Power of APEX Collections: When and How to Use Them EffectivelyWhen we build applications in Oracle APEX, we often need a place to store temporary data, handle multi-step forms, or process files before inserting them into actual tables. For these kinds of situations, APEX Collections are one of the most useful f...Dec 11, 2025·3 min read