APEX + AI = Awesome

Explore how APEX can empower developers to be more productive than ever before by leveraging the power of generative AI and machine learning models across the entire stack.

AI-Assisted Development (GenDev)

Oracle APEX unlocks new capabilities for Generative Development (GenDev) that make it easy to build intelligent applications that respond with precision and relevance. The APEX AI Assistant, a conversational companion, helps with tasks such as generating, optimizing, explaining, and debugging SQL queries, as well as assisting with HTML, CSS, JavaScript, and PL/SQL across APEX code editors. It also enables developers to create applications and custom data models using natural language prompts, simplifying the development process and increasing developer productivity.

Learn More Read Blog Post

  • Create Apps and Model Data using Natural Language

    Simply describe the kinds of pages, data, and features you want, and APEX AI Assistant puts together an application blueprint to get you started. You can further refine the application using the full Create App wizard or generate the application immediately.

  • Code Authoring and Debugging

    The APEX AI Assistant helps you author SQL queries over your application data model by understanding your natural language description of what data you want to retrieve. This eliminates the process of looking up exact database table and column names or precise SQL syntax. Need help with HTML, CSS, JavaScript, or PL/SQL? Use the APEX AI Assistant in any code editor across APEX to diagnose code issues and suggest solutions.

AI-Powered Apps

Oracle APEX offers a range of AI capabilities that empower developers to build intelligent, context-aware applications.1 From AI-generated text to AI assistants leveraging retrieval-augmented generation (RAG) for conversational interfaces and vector-based search enhancements, these advancements enable developers to create applications that are both smarter and more user-centric.

You can also integrate OCI AI services to add powerful AI features, enabling personalized experiences, natural language processing, and more. Use OCI Vision for image recognition and classification, or OCI Speech for transcription and speech understanding, making visual and audio content more accessible and actionable.2

  • Conversational AI Dialogs

    Easily configure AI-powered conversational experiences using a new dedicated Dynamic Action. Simply provide the system prompt, welcome message, and customize the appearance, choosing whether to display the AI assistant within a modal dialog or inline directly on your page.

  • AI Prompts and RAG Data Sources

    Define AI Assistant prompts within AI Configurations and enhance responses by sending additional context data based on a SQL query, function output, or static text. These RAG sources can be conditional and are re-evaluated with each user prompt, ensuring responses stay relevant and up-to-date.

  • Vector Search Support

    Empower end-users to find the most relevant results with semantic similarity searching. A new Search Configuration type simplifies adding Oracle Database 23ai vector search to your applications. Specify details like index usage, distance metrics, and maximum vector distance, then watch users smile as they find what they're looking for more quickly than ever.

  1. Is GenAI included in APEX free of charge?
    APEX does not charge you for using GenAI. If you possess a GenAI API key, you can use it within APEX at no additional cost. Customers will be charged by the respective AI providers as per their pricing model.
  2. Can I use any GenAI Service within APEX?
    APEX offers native integrations with the following Generative AI services: OCI Generative AI, OpenAI, and Cohere. Developers can connect with other Generative AI services via REST APIs as part of their APEX apps. APEX also supports ONNX models loaded into Oracle Database 23ai for performing vector embeddings directly within the database.

Blog Posts

Explore blog posts to discover how to utilize and implement AI features in Oracle APEX.

Customers using AI with Oracle APEX