Think APEX

Backing Up Oracle APEX Applications to GitHub Automatically (No External Tools Needed) Before every deployment, I want a safe copy of my APEX application stored somewhere I can always get back to. In this post I'll show how to push a full application export to a GitHub repository, with the date in the folder name, using only PL/SQL inside APEX. It works on the free apex.oracle.com service, so you can try it without installing anything. What We Are Building A button in an APEX page that does this: Exports your application using APEX_EXPORT Sends the file to GitHub through the GitHub REST API Stores it in a dated folder, like backups/2026-10-06_133022/ Every click creates a new restore point you can see in GitHub's history. backups/ 2026-10-06_133022/ f185224.sql <- single-file export, restore with App Builder > Import split/f185224/... <- optional, one file pe...

Protect Sensitive Data from AI with Oracle Database The rapid adoption of Artificial Intelligence (AI) and Large Language Models (LLMs) is transforming how enterprises operate, innovate, and interact with customers. From intelligent chatbots and AI-powered applications to autonomous agents capable of analyzing enterprise data, organizations are increasingly connecting AI systems directly to business information. However, this creates a critical security challenge. Enterprise databases often contain Personally Identifiable Information (PII), financial information, confidential business data, customer records, and other sensitive information . If an AI agent is given excessive access to this data, a malicious or carefully crafted prompt could potentially cause the agent to retrieve or expose information that the user should never be allowed to see. This leads to an important principle: Important Principle AI security should not depend entirely on AI guar...

Mastering Oracle Virtual Private Database (VPD): A Comprehensive Guide to Row-Level Security In today's data-driven world, securing sensitive information is paramount. While firewalls and network security protect your perimeter, true defense-in-depth requires security at the data layer itself. Enter Oracle Virtual Private Database (VPD) , a powerful feature also known as Row-Level Security (RLS) or Fine-Grained Access Control (FGAC). This blog provides an in-depth exploration of Oracle VPD, starting from the fundamentals and progressing to advanced concepts, complete with practical implementations and best practices. 1. What is Oracle Virtual Private Database (VPD)? Oracle VPD is a security feature that allows database administrators and security personnel to dynamically control data access at the row and column level. Instead of relying on the application layer to filter data (e.g., adding WHERE user_id = ? to every query), VPD enforces these rules directly ...

Architecting an AI Video Assessment Engine in Oracle APEX with Google Gemini Multimodal A deep technical breakdown of handling binary media streams, two-stage AI orchestration, database state machines, and relational JSON parsing natively within Oracle APEX. In enterprise applications, evaluating human communication—such as analyzing body language, vocal modulation, facial expressions, and speech relevance—has traditionally required standalone microservices built in Python or Node.js. Many development teams assume that because Oracle APEX is a database-centric platform, it is ill-suited to orchestrate heavy multimedia processing and multimodal artificial intelligence. In Speech Nova , we challenged that convention. By leveraging the native capabilities of Oracle Database, APEX's internal web service engine, and Google Gemini's multimodal vision and speech processing, we engineered an end-to-end evaluat...

Introduction Building an enterprise AI application requires more than just embedding a chat widget. It demands structured data ingestion, strict relational persistence, dynamic server-side document compilation, and high-resolution export. This guide provides a comprehensive, step-by-step implementation blueprint. Any Oracle APEX developer or architect can follow these component specifications and design patterns to replicate an AI-Powered Multi-Template Resume Builder & Vector Export Engine from scratch. Core Architecture: User Chat → APEX AI Assistant → Declarative Tool Contract → 11-Table Relational Schema → Server-Side HTML CLOB Generator → Vector PDF Engine. System Architecture & Component Flow 1. Chat Intake → 2. APEX AI Assistant → 3. Tool Calling → 4. 11 Relational Tables → 5. Dynamic Content (CLOB) →...