Categories
AI APEX

APEX 26.1 App Enhancements With APEXlang

In this article we will generate a APEX 26.1 app using an AI and then direct an AI to edit that application in VS Code and push it back to the app builder to run it. This is made possible by the new feature of APEX 26.1 APEXlang, which is described by Oracle as “…an […]

Categories
APEX

Oracle APEX 26.1 IR Row Selector

It looks like it’s a small tweak, but it’s a highly significant enhancement that APEX 26.1 adds a native row selection for Interactive Reports. Previously this could be done in multiple ways, but it it really makes development a lot easier having this capability as a native component. In this article we are going to […]

Categories
AI APEX GenAI

Oracle APEX 26.1 AI Agents

AI Agents are proliferating across many tools and now Oracle APEX 26.1 introduces built in both AI Agents and AI Tools. To demonstrate this facility, I will use the EMP and DEPT tables from my Oracle 26ai database and build a small People Cost Review page within an application which invokes an AI agent supported […]

Categories
APEX GenAI

Oracle APEX 26.1 AI Interactive Reports

One of the “marquee” features of the new Oracle APEX 26.1 release is the ability to add natural language queries to Interactive Reports (IR). So, as well as having full IR ability, the user can ask a question like “show me all employees in Sales earning more than 1500” as an alternative to manually setting […]

Categories
Oracle Analytics

HTML Visualisations with iFrames in Oracle OAC

Introduction The May 2026 update to Oracle Analytics Cloud (OAC) introduced the iFrame visualisation. The documentation describes this as a way to embed external content in a workbook canvas using either a URL or inline HTML. “Use an iframe visualization to securely embed external content in a workbook canvas. Embed the content using either a […]

Categories
Oracle Spatial

Oracle AI Database 26ai – now with Spatial Studio Integrated

Spatial capability is a powerful feature of the Oracle AI Database 26ai allowing us to create analytics to determine things like Spatial studio has been available as a separate downloadable application for some years and is a great help to visually answering these sorts of questions and creating SQL for us to use in other […]

Categories
Uncategorized

Heatmap Analysis in Oracle Analytics

The March 2026 update to Oracle Analytics Cloud has a lot of great new features introducing new capabilities across visualisations, AI, and data preparation. In this article we are going to look at the metric-based colouring for heatmaps. Let’s show it in action using a fictional UK coffee chain called Daynes Coffee House UK, with […]

Categories
AI GenAI Select AI

Natural Language Q&Ai with Oracle 26ai

Many organizations desire to have as real-time as possible analytic systems that give them the capability to analyse their data sourced from various core business systems, at quite a granular level with all the built in governance and security to keep that data secure. I am being asked with increasing frequency about how users can […]

Categories
Uncategorized

Use AI to ask questions and create charts with Oracle 26ai SQLcl MCP Server.

In this article I am going to use an Oracle 26ai database, an MCP server, an agent and a LLM to ask a bunch of questions of my data and even create a chart in python – all without me having to write any code. This is not a fully detailed process for installation as […]

Categories
Fusion Data Intelligence

Augmenting Oracle Fusion Data Intelligence

Oracle Fusion Data Intelligence (FDI) allows us to enhance the out of the box offering by bringing in additional data from the source Fusion Cloud Applications system. From the available data stores, called PVOs, we can select additional columns and create an augmentated dataset which can be used in extraction pipelines. With this technique, additional […]