Skip to main content

Posts

Oracle APEX Integration with Gmail Notifications using Google Apps Script

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: ...
Post a Comment
Read more
Recent posts

Building a Professional Resume Builder with Oracle APEX

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 ...
Post a Comment
Read more

APEX 26.1 New Features

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: ...
Post a Comment
Read more

Getting Started with DBMS_PROFILER in Oracle Database

Oracle PL/SQL · Performance Tuning What is DBMS_PROFILER ? An interface to profile existing PL/SQL applications and identify performance bottlenecks - collecting and persistently storing granular execution data at the virtual machine level. Overview DBMS_PROFILER provides an interface to profile existing PL/SQL applications and identify performance bottlenecks. It lets us collect and persistently store profiler data. The profiler gathers information at the PL/SQL virtual machine level , including the total number of times each line has been executed, the total time spent on that line, and the minimum and maximum execution times for each line. Data Tables Table Name Description PLSQL_PROFILER_RUNS Metadata per run (run ID, owner, date, comment, total time) ...
Post a Comment
Read more

Interactive Grid Tips (Part-1)

Selection Toolbar Events Validation Styling Advanced Selection 1 Get Selected Row Primary Key Return selected row PK values to a page item. Two approaches depending on APEX version. Selection APEX 24.2+ Before 24.x Copy // Initialization JavaScript Function function (options) { options.defaultGridViewOptions = { selectionStateItem: "P22_SELECTED_IDS" }; return options; } Copy var ig$ = apex.region( "EMP" ).call( "getViews" , "grid" ); var model = ig$.model; var selectedIds = []; ig$.view$.grid( "getSelectedRecords" ).forEach( function (rec) { selectedIds.push(model.getValue(rec, "EMPNO" )); }); $s ( "P22_SELECTED_IDS" , ...
1 comment
Read more