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 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, [...]
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 [...]
Building on our previous discussion about integrating OpenAI Assistants with Oracle APEX, this article focuses on structuring and displaying user interactions efficiently. Instead of frequent database queries, APEX collections provide session-based storage for optimized performance. The PR_LOAD_MESSAGES procedure initializes the conversation by retrieving system messages, structuring collections, and handling errors. Messages are displayed dynamically using [...]
Previously, we explored the OpenAI API's completion models, which enabled text generation and language-based automation. Now, we are shifting our focus to OpenAI's new Assistant API, a more structured approach that enhances interactions by integrating memory, function calling, and multi-step reasoning. This new paradigm allows for more sophisticated and context-aware AI-driven assistants that can work [...]
