How to Turn Natural Language Prompts into APEX Charts using Gen AI

Описание: In this video we demonstrate how to turn natural language text prompts into fully interactive charts in Oracle APEX. Using Generative AI, we convert a user’s plain English request into a structured JSON payload that includes a syntactically correct SQL statement, chart type, title, and axis labels. We then validate and sanitize the SQL, populate an APEX collection from the query results, and render the chart.
You’ll see a practical example of the following flow: combine the user prompt with database profile metadata, send a strict system prompt to the model, parse the JSON response, validate the generated SQL, and wire the results into an APEX chart region. The charts themselves are defined in APEX; GenAI supplies the data source and chart attributes.



Documentation:
GitHub Repo: https://github.com/ShayneJaya/APEX_GE...

How to setup the APEX AI Assistant:    • How to Setup the Oracle APEX AI Assistant ...  

OCI Meta Llama 3.1 Model: https://docs.oracle.com/en-us/iaas/Co...

Getting Started with APEX: https://apex.oracle.com/en/learn/gett...

Intro to SelectAI for APEX:https://blogs.oracle.com/apex/post/co...

Code Innovate:    • Oracle Code Innovate Retools, Embraces Vir...  

#codeinnovate #apex #developerexperience #oci #adb