DataVizMark
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
In the previous article we looked at MCP with Oracle SQLcl and analysed data from an Oracle 26ai autonomous database. Now in the Oracle Analytics Cloud November 2025 update, an MCP server is also available, and we will look at this in action. Mike Durran and Ravi Bhuma wrote a great article on setting up […]
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 […]