Create and Maintain SQL Using Natural Language with APEX AI Assistant

Introduction

APEX AI Assistant in Oracle APEX lets you generate SQL queries using natural language prompts. Without needing to memorize the syntax, table names, or relationships between tables, you can simply type in your query in natural language to generate SQL. APEX AI Assistant uses Oracle Cloud Infrastructure Generative AI to identify relevant tables and generate syntactically accurate SQL queries. APEX AI Assistant understands how your tables are related and can even generate queries that join multiple tables. If the generated query isn’t accurate, you can iteratively interact with APEX AI Assistant to further refine the query by providing additional instructions. This simplifies the development process and empowers developers at all skill levels to build data-centric applications efficiently and effectively.

Beyond generating SQL statements, APEX AI Assistant can also provide general assistance with tasks such as explaining code, improving code, and analyzing and fixing errors. It’s like having a personal SQL mentor that explains answers with concrete examples to help you learn. With APEX AI Assistant, you can write, learn, and debug code without leaving APEX App Builder. This can help enhance productivity and allow for higher accuracy in code generation and maintenance, which can ultimately lead to more robust and reliable applications.

Demo

Prerequisites and setup

1. Oracle Cloud account—sign-up page
2. Oracle Cloud Infrastructure—documentation
3. Oracle APEX—documentation
4. OpenAI models—documentation
5. Cohere models—documentation

Getting started

• Hands-on workshop with step-by-step instructions