Oracle APEX AI: the AI Assistant & generative app building

Since APEX 24.x, AI is a first-class part of the builder. This guide switches it on and tours the three places you'll use it daily: the AI Assistant, create an app from a prompt, and AI-assisted SQL.

Connect a Generative AI service

In Workspace Utilities → Generative AI, create a service: pick the provider (OCI Generative AI, OpenAI, …), paste the credential, and mark it as the default for the workspace.

Use the AI Assistant in Page Designer

• Open any page → the Assistant panel: ask it to *"add a validation that SAL must be positive"*.
• Generate SQL for a region: *"top 5 customers by revenue this year"* → reviewable query.
• Explain existing code: select a process and ask *"what does this do?"*

Create an app from a prompt

App Builder → Create → "Create App using Generative AI"

› An expense-tracking app: employees submit expenses with receipts,
  managers approve, finance sees a monthly dashboard.

APEX drafts the data model and pages; you refine in the builder. Pair it with the vibe-coding guide for the file-based workflow.

Check your understanding