Evolve with APEX

Oracle APEX · Feature Spotlight You Can Now Just Talk to Your APEX Reports Interactive Reports just picked up a natural-language layer. Type what you want to see — even against a plain old EMP table — and the report configures itself. No menu-hunting required. salesmen earning over 3000, sorted by salary Filter: JOB = SALESMAN Filter: SAL > 3000 Sort: SAL ↓ So what actually changes Say you're sitting on the classic EMP table and you type "salesmen earning over 3000, sorted by salary." Instead of opening a filter dialog, setting JOB equal to SALESMAN, adding a condition on SAL, and then sorting the column yourself, the report just rearranges itself. The filter on JOB gets applied, the SAL > 3000 condition drops in, the sort order updates — and you're looking at exactly what you asked for, without ever opening a menu. What's happening underneath is less magical than it sounds...

agent: online AI Agents in Oracle APEX — Part 2: Building the Live Demo The config, the tools, the button, and what to type at it. This picks up straight from Part 1 — no theory this time, just the build. I'm using two small tables, EMP_D and DEPT_D , so the classic schema stays out of the way of the actual point. By the end, you'll have an agent that looks up employees, summarizes salaries by department, hires someone new, and highlights a row on the page — all from a chat box. 01 Create the AI Agent Shared Components → Tasks → AI Agents → Create. First, APEX needs an AI Service configured — that's where your provider API key (OpenAI, Gemini, etc.) lives. Workspace Utilities → AI Services → Create Static ID + pick your model — I used command-a-03-2025 , fast and cheap enough to hammer with test prompts Paste your API key under Credentials — APEX auto-wraps it in a Web Credential, so it never sits exposed in page source Hit Test Connection be...

AI Agents in Oracle APEX: what they actually are Oracle APEX • Part 1 of 2 AI Agents in Oracle APEX: what they actually are Every time a new APEX version is released, I like to explore the new features before I start building applications. When APEX 26.1 came out, one feature immediately caught my attention: AI Agents . At first, I assumed it was just the AI Assistant with a few updates. After spending some time exploring it, I realized it's actually something quite different - and that made me want to understand it better. 1 Assistants answer. Agents act. An AI assistant only talks. Ask it something and it responds using what it already knows - summarizing, rewriting, answering from a document. It never actually touches your application; it just discusses it. An AI agent does something with the request. Instead of replying straight away, it runs a small loop: Understand what you're asking Work out what i...