Think APEX

Oracle APEX • PL/SQL • Dynamic Reporting Have you ever needed to build a dashboard where users select a report from a dropdown list, and the page dynamically renders the query results? A common design pattern is to centralize your report queries in a database table: REPORTS_TABLE ( QUERY_ID , REPORT_NAME , QUERIES , CREATE_BY , CREATE_DATE ) However, if you've tried implementing this with an Interactive Report or Interactive Grid , you likely ran into database metadata conflicts or compilation errors when switching between reports. In this post, we will explore why standard reports struggle with dynamic structures and provide a step-by-step guide to building a fully dynamic report viewer using Classic Reports and Generic Columns in Oracle APEX. The Challenge: Fixed Metadata vs. Dynamic Columns Oracle APEX Intera...

Google Sign-In (SSO) with Oracle APEX: Full Step-by-Step Integration This guide walks through every single step of wiring up Google Sign-In for an Oracle APEX app on apex.oracle.com — starting from creating the Google Cloud project, all the way through configuring the APEX Authentication Scheme. No steps are combined or skipped. 🏗️ Architecture Overview User Browser Clicks "Sign in with Google" → APEX App Redirects to Google OAuth2 → Google Consent Screen User authenticates → APEX Callback URL apex_authentication.callback → APEX Session Created User logged into app Part 1 — Google Cloud Console PROJECT SETUP 1 Sign in to Google Cloud Console Go to console.cloud.google.com and sign in with the Google account that will own this OAuth integration. 2 Create a new project Click the project dropdown (top bar) → New Project → give it a name (e.g. apex-google-sso ) → Create. Wait for the project to finish provisionin...

Posting to LinkedIn from Oracle APEX: A Complete Beginner's Guide Free oracleapex.com tier · personal LinkedIn profile posting · step-by-step with every real error included If you've ever wanted a button in your Oracle APEX app that posts directly to your personal LinkedIn feed — no Zapier, no third-party middleman, just your own APEX app talking straight to LinkedIn's API — this guide walks through the whole thing, start to finish, including every mistake made along the way so you don't have to repeat them. By the end, you'll have: A LinkedIn Developer App configured for personal posting Two APEX pages: one to connect/authorize, one that handles LinkedIn's callback and does the posting A working "Post to LinkedIn" button that publishes text posts to your own profile This is written for a free oracleapex.com workspace, but the same steps work on any hosted or on-premises APEX instance — just adjust the domain. The Big Picture ...

APEX Integration with Gmail Notifications Introduction In many Oracle APEX applications, users want to see Gmail notifications directly within the application without opening Gmail. In this article, we will build a Gmail notification badge that displays the number of unread emails in the APEX Navigation Bar. Final Output Notification bell in the Navigation Bar Displays unread Gmail count Automatically refreshes every 60 seconds Works across the entire APEX application using the Global Page (Page 0) Architecture Gmail ↓ Google Apps Script ↓ REST Web App ↓ Oracle APEX (Page 0) ↓ Navigation Bar Badge Prerequisites Oracle APEX (Works on apex.oracle.com) Personal Gmail account Google Apps Script Internet access 1 Create a Google Apps Script Project Open https://script.google.com/ Click New Project. Rename the project. Ex: APEX Gmail Notification 2 Write the Google Apps Script Replace the default code with the following: ...

Oracle APEX · Technical Blog Building a Professional Resume Builder with Oracle APEX A deep dive into how APEX Collections, AI-powered text generation, and Dynamic Content Regions come together to create a seamless, end-to-end resume building experience. Overview The Resume Builder is a full-featured web application built on Oracle APEX that guides users through the entire resume creation process - from entering personal details to downloading a professionally formatted document. Rather than saving data prematurely to permanent tables, the application uses APEX Collections to temporarily hold user inputs across each step, keeping the experience lightweight, session-aware, and easy to manage. User data is organized into the following dedicated sections: Section Description Personal Information ...

Release Notes Referenced on Apex Ideas App Implementations — Implement Edition 1 Quick Pick on Lists The Quick Pick functionality for list-based items has been enhanced. We can now configure Quick Picks using options: Static - The quick picks are based on the static labels and values entered. SQL Query - The quick picks are based on the SQL query entered. Maximum Displayed Entries - The maximum displayed entries that will be rendered. Link Attributes - Enter HTML attributes that are associated with the display of each Quick Pick link. Example Type → SQL Query Query: SELECT DISTINCT DNAME D, DEPTNO R FROM DEPT Maximum Displayed Entries: 4 Link Attributes: class="my-quickpick" Inline CSS (Pill shape UI): .my-quickpick { display: inline-block; padding: 6px 14px; margin: 9px 4px 2px 0; border: ...