Create an AI-Generated SQL Query

You can create AI-generated SQL queries in the Oracle Autonomous Transaction Processing Database. This section provides an overview of performing this task.

To create an AI-generated SQL query, you must satisfy the prerequisites described in Manage AI Profiles.
  1. Create an Oracle Autonomous Transaction Processing Adapter invoke connection.
  2. Drag the Oracle Autonomous Transaction Processing Adapter into the integration canvas.
  3. On the Basic Info page, chose Select AI for SQL from the What operation do you want to perform list.
  4. Select a profile, then enter a SQL query in the Natural Language Query field in natural language. When complete, click Generate Query.


    The Select AI for SQL page is shown. Text has been added to the Natural Language Query field. Below this is the button for Generate Query.

    A list of parameters that fulfill the conditions provided in the natural language query is displayed.


    The Select AI for SQL page is shown. Below this is the select syntax. Add and Remove buttons appear. Below this is the Add SQL Parameter Values section. A table with columns for Parameter Name and Parameter Value is shown. The Parameter Name column includes a row with a parameter name enter. Cancel, Go back, and Continue buttons appear at the bottom.

  5. Double-click the input area in the Parameter Value column and provide values for the binding parameters.
  6. Click Add to add any additional binding parameters.
  7. Click Validate and Test SQL Query.
    If syntax validation is successful, the message Success! appears.


    The Select AI for SQL page is shown. The Validate and Test SQL Query button is shown. Below this is a Status box with a message of Success. Cancel, Go back, and Continue buttons appear at the bottom.