Skip to main content

Posts

Mastering Interactive Grids: Toolbar Customization with JavaScript

Mastering Interactive Grids: Toolbar Customization with JavaScript Oracle APEX › Interactive Grids › JavaScript Customization Mastering Interactive Grids: Toolbar Customization with JavaScript Deep Dive · ~12 min read · APEX 23.x / 24.x JavaScript The Interactive Grid toolbar is one of those features most developers accept as-is — a row of default buttons that do the job, but rarely match the specific workflows users actually need. What if you could add a one-click "Export Selected" button, inject a contextual "Approve All" action, or remove the buttons your users never touch? With a handful of JavaScript lines and the apex.region API, you can reshape the toolbar entirely. This section covers everything: understanding the toolbar's internal data model, adding custom buttons with PL/SQL callbacks, conditionally enabl...
Post a Comment
Read more
Recent posts

APEX Custom Auth Settings, Decoded!

Oracle APEX Security PL/SQL APEX Custom Auth Settings, Decoded Why I Build this I was building an internal APEX app — strictly for people on our corporate network. The default authentication worked, but it had a few things that kept bothering me. Anyone with valid credentials could log in from anywhere. Sessions expired with a useless error page. There was no audit trail — no way to know who logged in, when, or from where. And passwords were stored in plain text, which I just couldn't leave alone. So I did what any developer does — I built it myself. Custom authentication, from scratch, in PL/SQL. Turned out to be one of the best learning experiences I've had with APEX. Here's exactly how I did it. Img 1 : Head to Shared Components → Authentication Schemes → Create, choose Custom as the Scheme Type, and plug in your function and procedure names. Quick note before we get into the code — the s...
Post a Comment
Read more

JSON-Relational Duality Views in Oracle APEX

Oracle 23ai Deep Dive JSON-Relational Duality Views in Oracle APEX The complete guide to bridging relational tables and JSON documents storing data efficiently, accessing it flexibly. 📋 Table of Contents What Are Duality Views? The Problem They Solve Prerequisites Practical Example: Emp-Dept App Configuring in Oracle APEX CRUD Operations via Duality Views Key Benefits Summary 1 What Are Duality Views? In one of my Oracle APEX projects, I had a requirement to expose relational data as JSON for integration with external systems. The application needed to support both database transactions and API-based data exchange, which made the design slightly complex. Initially, I considered building REST APIs with manual JSON construction using SQL functions. However, maintaining that logic became difficult as the data model evolved. That’s when I explored JSON-Relational Duality View...
Post a Comment
Read more

Generate Custom PDFs in Oracle APEX with jsPDF

Generate Custom PDFs in Oracle APEX with jsPDF A complete step-by-step guide to building a client-side PDF generator with profile image embedding and PL/SQL database persistence. 📄 Step-by-step guide Oracle APEX jsPDF Dynamic Actions PL/SQL JavaScript "Picture this: your Oracle APEX application is polished, your users love it — but when they ask for a downloadable report with a profile picture and custom styling, you realize vanilla APEX isn't built for that out of the box. What if a single JavaScript library and one Dynamic Action could change everything?" Welcome to the world of jsPDF inside Oracle APEX . In this tutorial, we wire up a PDF generator that captures a user's name, email, phone number, and profile picture — renders them into a beautiful PDF layout — and saves everything to Oracle, all in one button click. ⓘ What you'll build: A dynamic PDF generat...
Post a Comment
Read more