Introduction to AI: The basics you need to know Artificial Intelligence (AI) is one of those terms that everyone hears but few truly understand. We see it in headlines, in apps, and in new products, yet when you ask people what AI actually is, the answers are often vague. Let’s change that. This post is [...]
Oracle 23ai takes search in Oracle APEX to the next level by integrating advanced AI capabilities directly within the database. With no need for external resources, everything from vector embeddings to search calculations is handled natively. This not only simplifies the process but also results in smarter, more accurate search experiences [...]
Introduction In collaborative application development, managing change safely is critical, especially when working with live environments or production-grade logic. Oracle APEX offers a built-in feature called Working Copies, which helps developers implement and test changes without directly modifying the active version of an application. Working Copies allow you to create an isolated, editable version of [...]
Introduction In Oracle APEX 24.2, Automation has become a key feature for integrating event-driven workflows directly into your low-code applications. This post introduces what Automation is, when to use it, and how it simplifies routine tasks like sending emails, synchronizing data, or executing business logic, without needing a full PL/SQL background. What is APEX Automation? [...]
In the first version of our semantic search implementation in Oracle APEX, everything hinged on manually written descriptions. Someone — maybe you, maybe a user — had to describe each image in words. Then we’d send that text to OpenAI to generate embeddings, store those vectors, and use them to build a smarter kind of [...]
In the first part of this series, we looked at how to enrich your data with meaning by generating embeddings using OpenAI’s API. We stored those vectors in our Oracle APEX app, laying the groundwork for a smarter kind of search — one that understands concepts, not just words. Now it’s time to go a [...]
Vector Search is a way to find things that are similar—not by matching exact words like a typical SQL LIKE '%cat%' search—but by comparing meaning. The basic idea is this: You take your data (text, images, whatever) and turn it into numbers—a list of numbers, actually—called a vector. Each vector lives in a multi-dimensional space, [...]
Introduction In a world where applications must be increasingly connected and interoperable, Oracle APEX and ORDS offer a robust platform for building and consuming RESTful APIs quickly, securely, and scalable. This tutorial walks you through how to build and consume an Oracle APEX REST API using ORDS, OAuth2, and both declarative and programmatic approaches. Basic [...]
Working with blockchain data in traditional enterprise environments can feel a bit like trying to mix oil and water. Between smart contracts, RPC nodes, ABI files, and all the other moving parts, it’s easy to get lost—especially when your main focus is building applications with Oracle APEX. In our previous article, we tackled this challenge [...]
Oracle Blockchain Platform is a preassembled PaaS solution that enables businesses to quickly deploy and manage blockchain networks. It includes all necessary components such as compute, storage, containers, identity services, and event management, along with an intuitive console for easy administration. Built on Hyperledger Fabric, Oracle enhances this open-source framework with automated provisioning, multi-cloud and [...]
