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...