2.1.2.2 SQL Mentor at Your Side

APEX AI Assistant is your SQL mentor. After registering the generative AI service APEX should use, this AI‑powered design-time companion is available in every code editor in App Builder. It can help you write, learn, and debug SQL on demand.

To write SQL, explain in English what data you need to work with, and APEX AI Assistant can help generate the statement to get the job done. To improve your understanding of SQL, APEX AI Assistant can help answer any questions or doubts you have. As you develop, it can also help suggest corrections to SQL when you encounter errors.

Figure 2-4 APEX Assistant Helps Write SQL

Description of "Figure 2-4 APEX Assistant Helps Write SQL"

Using Code Editor for SQL

In addition to accessing APEX AI Assistant in the SQL Workshop, SQL Commands page, you can also use it in the SQL Code Editor. This modal dialog is available throughout App Builder. Wherever you can specify SQL, APEX AI Assistant is one click away to help turbocharge your SQL authoring and education journey.