Use integrated AI Chat capability (called APEX Assistant) in Code Editors within App Builder.

To use APEX Assistant:

1. Create an Generative AI Service and enable the Used by App Builder setting. See Managing Generative AI Services.
2. Access a Code Editor. The examples that follow show the Code Editor in Page Designer.
3. Click APEX Assistant on the menu bar.
   
   

   
   Description of the illustration apex_assistant_button.png

   
   

   The first time you access APEX Assistant a consent dialog appears. Review the dialog carefully and click Accept to continue. APEX Assistant appears in the right pane.

   
   

   
   Description of the illustration apex_assistant_menu.png

   
   

   Note that the APEX Assistant menu contains two options:

   • Query Builder - Use Query Builder to get back a simple query.

     In Query Builder mode, the AI assumes all questions are in the context of the customer schema in the database. For example, if your request that the AI create SQL for tables that do not exist in the database, APEX Assistant's responses will not be very helpful.

   • General Assistance - Use General Assistance for general conversation, technical questions such as "Explain this" or "Improve this code." In General Assistance mode, APEX Assistant prompts you with default options such as Use Selection, Improve Selection, and Explain Selection.

4. Query Builder Example: Show average salary by department.
   1. From the menu, select Query Builder (if not already selected).
   2. In the Code Editor, select the query and click Use Selection.
   3. In Type your message here, enter show average salary of employee by department name and click Send Message.
   4. APEX Assistant responds with a query as shown in the following example.
      
      

      
      Description of the illustration query_builder_response.png

      
      
   5. Click Copy or Insert to copy or insert the response into the Code Editor.
   6. To clear the chat window, click Clear Chat.

   Tip:

   If a query throws an error, APEX Assistant switches to General Assistance mode. Click Help me fix this.
5. General Assistance example: Explain a selected query:
   1. From the menu, select General Assistance.

      APEX Assistant displays three options:

      • Use selection
      • Improve selection
      • Explain selection
   2. In the Code Editor, select the query and click Explain selection.

      APEX Assistant responds and describes the query.

      
      

      
      Description of the illustration general_assistance_response.png

      
      
   3. To clear the chat window, click Clear Chat.
6. General Assistance example: Help with SQL query errors:

   If your query throws an error, APEX Assistant can help troubleshoot the problem.

   For example, suppose you have the following query and have inadvertently left off the "s" at the end the table name.

   select rowid,
          ID,
          PROJECT,
          TASK_NAME,
          START_DATE,
          END_DATE,
          STATUS,
          ASSIGNED_TO,
          COST,
          BUDGET
   from EBA_DEMO_IR_PROJECT
   where (nvl(:P3_STATUS,'0') = '0' or :P3_STATUS = status)

   Since the table name should be EBA_DEMO_IR_PROJECTS, if you validate or try to run the query it throws the error:

   ORA-20999: Failed to parse SQL query! ORA-06550: line 11, column 24: ORA-00942: table or view does not exist.

   1. In the error, click Help me fix this.

      APEX Assistant reviews the code and error and suggests the table name may not be spelled correctly.

      
      

      
      Description of the illustration sql_query_error.png

      
      
   2. To clear the chat window, click Clear Chat.