Oracle APEX

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.

Read Blog Post

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.

AI Embedded in Oracle APEX

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. 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.

Embed AI in Your Oracle APEX Applications

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.

FAQs About Pricing

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. 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.

Empowering Search with OCI Vision in APEX

Learn how OCI Vision can be integrated with Oracle APEX to tap into the power of visual intelligence and transform data analysis capability

Read Blog

Integrating AI Powered Image Search in APEX

In this detailed video, walk through the step-by-step procedure to integrate OCI Vision with an existing Social Media App built using Oracle APEX.

Read Blog

Oracle APEX Meets OCI Generative AI

With the introduction of native Generative AI Service on Oracle Cloud Infrastructure (OCI), enabling your applications with generative AI capabilities has never been easier.

Read Blog

Using Select AI within APEX

Select AI, a new feature of Autonomous Database, harnesses the power of generative AI and Large Language Models (LLMs) to translate user input text into Oracle SQL queries.

Read Blog

Integrating an Oracle Digital Assistant Chatbot

Integrate Oracle Digital Assistant with your APEX app to create conversational AI-powered applications.

Read Blog

Handling Invoices with OCI Document Understanding

Explore the integration of Oracle APEX with OCI Document Understanding, and see the benefits and steps to incorporate these technologies seamlessly into your workflow.

Read Blog

Create and Maintain SQL Using Natural Language with APEX AI Assistant

Simply type your query in natural language to generate SQL based on your tables and relationships.

Read Blog

Vector Search Support in Search Configurations

Leverage Oracle Database 23ai vector search to bring AI-powered similarity search to your applications.

Read Blog

Retrieval Augmented Generation in APEX

Build a conversational chat user interface which generates responses based on data stored in the database.

Read Blog

Create Data Models Using AI

Use Generative AI to simplify the process of creating well-structured data models based on application requirements.

Read Blog

Customers using AI with Oracle APEX

Trailcon Leasing

Trailcon Leasing uses Oracle APEX and AI to modernize business processes leveraging OCI Document Understanding.

Watch Video

Syneos Health

Syneos Health uses Oracle APEX and AI to build their Clinical Trial Oversight System. 

Watch video

NIBIO

NIBIO improves sustainable forest management with Oracle AI Autonomous Database, APEX and AI on OCI.

Watch Video