Learn · 13

Tested, multilingual Oracle + AI guides

AI with Oracle APEX, vibe-coding, local LLMs over APEX, and Oracle 26ai's AI features — interactive, hands-on and free, forever.

Install Oracle 26ai + APEX 26.2 with Docker

Flagship — start here

git clone https://github.com/Mohamedhrby/oracle-26ai-apex-docker.git
docker compose up -d

A clean, tested local stack — Oracle AI Database 26ai Free, ORDS 26.3 and APEX 26.2 in official containers — on Windows, macOS or Linux. APEX installs itself.

Beginner · 3 min readRead the guide →

Beginner

2 · 6 min read

  1. Start hereDevOps3 min readInstall Oracle 26ai + APEX 26.2 with DockerA clean, tested local stack — Oracle AI Database 26ai Free, ORDS 26.3 and APEX 26.2 in official containers — on Windows, macOS or Linux. APEX installs itself.
  2. AI3 min readOracle APEX AI: the AI Assistant & generative app buildingTurn on APEX's built-in AI — APEX Assistant in the builder's code editors, Create App Using Generative AI, the Show AI Assistant dynamic action and the APEX_AI package — and wire it to a provider.

Intermediate

7 · 35 min read

  1. APEX3 min readVibe-code Oracle APEX with Claude Code + APEXlang (APEX 26.1+)Export your APEX app as APEXlang files, edit it in VS Code by chatting with Claude Code, then validate and import it back with SQLcl.
  2. AI3 min readRun a local LLM (Ollama) inside Oracle APEXPrivate, on-prem AI for APEX — call a local Ollama model from PL/SQL or register it as an APEX Generative AI Service, so prompts never leave your network.
  3. APEX9 min readUpgrade Oracle APEX 24.1 to 26.2Upgrade a self-managed APEX 24.1 (or any release from 18.1 onward) to APEX 26.2: prerequisites (ORDS and SQLcl 26.3), backups, apexins.sql, new images, post-upgrade checks, rollback and clean-up.
  4. DB2 min readOracle AI Database 26ai Vector Search for app developersBuild RAG and semantic search right inside the database with native VECTOR columns, VECTOR_DISTANCE and vector indexes.
  5. DB3 min readOracle DB AI: Select AI & natural-language SQLAsk your Oracle database questions in plain English with Select AI: set up the grants, credential and AI profile, then generate, inspect and run SQL. Includes where Select AI runs and what data it sends to the AI provider.
  6. AI7 min readGitHub Copilot Enterprise for Oracle developers: PL/SQL, APEX and SQLclTeach Copilot your PL/SQL and APEXlang rules with repository instructions and prompt files, then connect agent mode to a local Oracle database through the SQLcl MCP Server.
  7. AI8 min readClaude for Oracle work: picking a Claude 5 model and designing agentsWhich Claude model to use for PL/SQL refactors, APEX edits and bulk Forms documentation, what each costs, and how to set up Claude Code with CLAUDE.md, subagents, skills and the SQLcl MCP Server.

Advanced

4 · 11 min read

  1. Forms2 min readReverse-engineer Oracle Forms with AIExtract business logic, blocks, triggers and dependencies from legacy FMB modules with an AI agent — the first step of any safe migration.
  2. Forms1 min readGenerate an Oracle Forms modernization blueprintTurn the reverse-engineered inventory into an AI-drafted blueprint that maps each Forms object to a proposed APEX equivalent — with a risk rating you review.
  3. DevOps3 min readCI/CD for APEX with GitHub ActionsPut your APEXlang app under source control and ship it on every push with an automated pipeline.
  4. AI5 min readHow I build Oracle apps with a team of AI agentsOne lead, parallel worker lanes, an adversarial reviewer at three fixed moments and a traffic controller — plus the parity tests, budget pacing and security fences that keep it honest.