SSsaurabh shirkeinsaurabhshirke.hashnode.dev路4h ago 路 3 min readUseful HTML & CSS Add-ons to Enhance Your Oracle APEX PagesA great Oracle APEX application is more than just functionality鈥攊t should also provide an intuitive and visually appealing user experience. While Universal Theme offers many built-in components, addin00
SJSushama Jangleinoracleapexsessionstate.hashnode.dev路1d ago 路 8 min readIntegrating Oracle APEX with UiPath: Automating Enterprise Business Processes馃殌 Introduction One of the biggest misconceptions in enterprise application development is believing that the job is finished once users click Submit. In reality, that's often where the real business 00
RKRavi Kumar Yadavingenerate-absolute-urls-in-oracle-apex.hashnode.dev路17h ago 路 4 min readEnterprise REST APIs in Oracle Database: Building High-Performance JSON Services with ORDS & PL/SQLExecutive Summary As modern enterprise architectures shift toward decoupled microservices and reactive front-end frameworks, expose-and-consume patterns inside Oracle Database are essential. Oracle RE00
SJSushama Jangleinoracleapexsessionstate.hashnode.dev路2d ago 路 6 min readOracle APEX Error to Solution: The Debugging Playbook Every Developer Should Know馃摉 Introduction Last month I spent almost an hour looking at a page process because I was convinced the PL/SQL was wrong. The real issue turned out to be a NULL page item in Session State. Since then,00
RKRavi Kumar Yadavingenerate-absolute-urls-in-oracle-apex.hashnode.dev路1d ago 路 5 min readReal-Time Asynchronous Processing in Oracle APEX Using PL/SQL DBMS_SCHEDULER & APEX_BACKGROUNDExecutive Summary In high-throughput enterprise applications, performing long-running data processing, third-party API integration, or heavy document generation synchronously inside an APEX page submi10
SJSushama Jangleinoracleapexsessionstate.hashnode.dev路3d ago 路 6 min readFrom Standard Report to Excel-Like Experience: Enhancing Oracle APEX Interactive Report with Frozen Columns馃憢 Introduction Have you ever opened an Oracle APEX Interactive Report and found yourself scrolling endlessly across dozens of columns, only to lose sight of the key information you were comparing? If10
SSsaurabh shirkeinsaurabhshirke.hashnode.dev路3d ago 路 3 min readMastering Editable Interactive Grids in Oracle APEXOne of the most powerful features in Oracle APEX is the Editable Interactive Grid (IG). It allows users to insert, update, and delete multiple records directly from a grid without creating a separate 00
SSsaurabh shirkeinsaurabhshirke.hashnode.dev路3d ago 路 3 min readOracle APEX Validations Explained: Which Validation Method Should You Use?Validation is one of the most important parts of any Oracle APEX application. It ensures users enter correct and complete data before it reaches your database. Oracle APEX provides multiple ways to va00
SSsaurabh shirkeinsaurabhshirke.hashnode.dev路6d ago 路 4 min readDifferent Report Types in Oracle APEX: Which One Should You Use?Oracle APEX offers several report types. Each created for a specific purpose. Using the right report not only improves the user experience but also makes your application easier to maintain. In this b00
SSsaurabh shirkeinsaurabhshirke.hashnode.dev路Jul 27 路 4 min readWhat Are Global Page Items in Oracle APEX and When Should You Use Them?When building application in Oracle APEX, sometimes you need to access the same value across multiple pages. For example, you may need to store the current user's role, user details or other common va43SKR