Invoke Select AI for SQL Page

Select a user profile that you have registered in the Oracle Autonomous Transaction Processing Database. Then, enter a query in natural language. Add binding parameters, if required, validate, and test the generated query.

Element	Description
Select Profile	Displays a list of profiles that have been registered in the Oracle Autonomous Transaction Processing Database. Select one from the list. Note: All registered profiles must have access to the required database tables. See Manage AI Profiles.
Natural Language Query	Enter the natural language query. Note: Follow these guidelines: Write the query/prompt in simple English language. Write the statement clearly and explicitly. Include schema and table details and validate foreign key relationships for accurate results. Do not include quotes ("") or any other special characters.
Generate Query	Click to generate the SQL query based on the natural language query provided.
Parameter Name	Displays a list of parameters that fulfill the conditions mentioned in the natural language query.
Parameter Value	Double-click the input area and provide values for the binding parameters.
Add	Click Add to add any new or additional binding parameters. Note: You must ensure that the generated SQL query is in accordance with the parameters added.
Remove	Click Remove to eliminate one or multiple binding parameters. Note: You must ensure that the generated SQL query is in accordance with the parameters removed.
Validate and Test SQL Query	Click to validate the SQL query syntax.
Status	Displays the SQL query syntax validation status. When syntax validation is successful, a Success! message appears.

See Create an AI-Generated SQL Query.