Cloud Coaching - Select AI in Oracle APEX

Use natural language to analyze your data in Oracle APEX.
Join our Oracle Cloud Coach webinar to explore the power of Oracle APEX integrated with Select AI. In this session, you'll get a brief introduction to Oracle APEX and Select AI, followed by a live demonstration on how to seamlessly integrate Select AI with your Autonomous Database (ADB) using ChatGPT.
Discover how this integration can streamline your database interactions and elevate your application development capabilities.
Presenters and contributors:
- Cristina Varas Menadas, Cloud Solutions Engineer EMEA Data Development Specialist, Oracle
Check and register below for the upcoming sessions:
bit.ly/3NXe0qB
Join us on our Slack community:
oracle-emea-pu...
Note: This is a recording of the live event from July 24th. Screens and flows may have changed.
If you liked this session and would be happy to leave feedback on it, please reach us at: [e-mail].
#genai #dcx
----------------------------------------------
Copyright © 2024, Oracle and/or its affiliates.

[@bogdanf]

Fantastic video!

[@artemmatovka7936]

Great event thank you Violeta and Christina 🎉🎉🎉

[@senthilmurugan]

very useful presentation to create the AI apex application in oracle

[@Dmitro88]

Genial

[@Dmitro88]

👍🏻

[@ioannisremediakis7323]

When adding multiple tables in the object list in the profile, will it understand the foreign key constraints so you can have questions based on descriptions on the lookup tables for example? Can you give an example of how to contract the create_profile?

[@oracledevs]

Yes, adding multiple tables in the object list in the profile can enable AI models to understand foreign key constraints and allow you to ask questions based on descriptions in lookup tables. When you define the relationships and constraints properly, the AI can leverage these to provide more accurate and contextually relevant responses.
To create a profile that includes multiple tables with foreign key constraints in Oracle APEX using the approach similar to the Select AI example, follow these steps:
1. Define the Tables and Relationships:
Ensure your database tables are properly defined with foreign key constraints. E.g:
CREATE TABLE departments (
department_id NUMBER PRIMARY KEY,
department_name VARCHAR2(100)
);
CREATE TABLE employees (
employee_id NUMBER PRIMARY KEY,
employee_name VARCHAR2(100),
department_id NUMBER,
CONSTRAINT fk_department
FOREIGN KEY (department_id) REFERENCES departments(department_id)
);
2. Create the Profile:
Define a profile in your APEX application that includes these tables and their relationships. The profile configuration will help the AI understand the data context and relationships.
You can create the profile with the code provided in the demo with a small modification for adding the foreign key relationships. E.g:
BEGIN
DBMS_CLOUD_AI.create_profile(
profile_name => 'OPENAI_APEX',
attributes => '{
"provider": "openai",
"credential_name": "OPENAI_CRED_APEX",
"object_list": [
{
"owner": "",
"name": "employees",
"primary_key": "employee_id",
"columns": ["employee_id", "employee_name", "department_id"]
},
{
"owner": "",
"name": "departments",
"primary_key": "department_id",
"columns": ["department_id", "department_name"]
}
],
"foreign_keys": [
{
"child_table": "employees",
"child_column": "department_id",
"parent_table": "departments",
"parent_column": "department_id"
}
]
}'
);
END;
/
For more info please visit this article: medium.com/@cristina.varas98/enhancing-data-analysis-with-select-ai-in-oracle-apex-9d00b070a073

[@nesdi6653]

This video has better audio, sessions need to do AI audio processing.

[@callicantzaro1724]

Great video!