Skip to main content

Posts

@Mention Autocomplete in Fields

ORACLE APEX How I Added @Mention Autocomplete in Oracle APEX Fields Type @ in a field, pick a customer from a list, and the name or email is filled in for you. Just like Slack, but inside your own APEX page. Live Demo Tribute.js AJAX Callback apex_json Textarea highlight Mention chips I wanted one simple thing in my Oracle APEX app. When I type @ in a text box, a small list of customers should open, like in Slack or WhatsApp. I pick one, and it goes into the text. I am still learning APEX, so I thought this would take one hour. It took me almost two days. I got the dropdown wrong, then the email field wrong, then the colors wrong. In this blog I will show you what I tried, what failed, and the final code that works for me. 1 What I built My page number is 20, so all my items start with P20_ . I made two fields: 💬 Comments A textarea. Type @ , pick a customer, and @Full Name is added. 📧 Email Address A text field....
Recent posts

AI Agents in Oracle APEX - Part 3: What’s New in 26.2

agent: online Oracle APEX • Part 3 AI Agents in Oracle APEX ; Part 3: What’s New in 26.2 Provider APIs, reasoning effort, agent navigation, and a database that says no. ⚙ Provider API 🧠 Reasoning Effort 🧭 AI Navigation 🛡 Deep Data Security Try the Live Demo → Read Part 2 In Part 2 I built an HR agent that looks up employees, changes salaries and deletes rows. Then APEX 26.2 landed on October 6, and the AI Agents section of the release notes made me want to go back and rebuild parts of it. This post covers what changed and what I’d change in my demo because of it. 📌 Availability: 26.2 is out for on-premises installs first. Autonomous Database and the OCI rollout follow over the coming weeks, so check your environment before trying this. 1 Provider API: you pick how APEX talks to the model Until now, APEX talked to each provider through one fixed API. 26.2 add...

Interactive Report Enhancements in Oracle APEX 26.2

ORACLE APEX 26.2 Interactive Report Enhancements Interactive Reports are the part of APEX that end users touch most. Build a report once and users can filter, sort, pivot, chart and group it however they like, with no extra pages or SQL. APEX 26.1 added a natural-language layer. APEX 26.2 refines both the classic and the AI-driven sides, and it changes a few defaults you should know about before you upgrade. ✨ Modern interface ⌨️ Key phrases 🧮 AI computed columns ⚠️ Upgrade impact 1 A modernized report interface The first thing you'll notice is the refreshed look: cleaner layouts, better spacing, more consistent controls and better behavior on small screens. The functional changes are more interesting. Search and filter chips Active filters and report settings appear as chips, so users can see how the report is configured without reopening dialogs. They can also remove a single filter without rebuilding everything. The search bar also shows column chip...

Oracle APEX 26.2 What's New?

RELEASE 26.2 · OCT 2026 Oracle APEX 26.2 What's New? A simple guide to the biggest updates. 6 big updates AI more control DB built-in security APEX 26.1 introduced big ideas like APEXlang, AI Agents and AI Interactive Reports. APEX 26.2 makes those ideas easier to use in real projects. It is available now for on-premises installs, and the Autonomous Database version follows soon. It works with Oracle Database 19c and Oracle AI Database 26ai. 📄 Import One File Change one page and import just that page, not the whole app. 🧠 AI Thinking Level Choose how hard the AI should think: quick or deep. 📊 New Interactive Report Cleaner screens, better filters and quick typed commands. 🔒 Deep Data Security Data rules live inside the database, covering every access path. ☁️ Keyless OCI Access Connect to Oracle Cloud without storing private API keys. ⚙️ Workflow & Theme Draft ...