Setting an AI Profile on a Database Connection

You must associate one of the AI Profiles that you have created with the Oracle Database connection that you wish to use with Select AI.

1. In the Server Explorer, connect to the Autonomous Database as your database user.

2. Right click on the database connection node and in the menu choose Select AI, then Set Default AI Profile for Connection.

3. In the Set Default AI Profile For Connection Dialog that opens, select the AI profile from the dropdown list.

4. Right click on the connection and select Open New SQL File, or Open Existing SQL File.

5. In the SQL file, if you did not choose a Default AI Profile in the connection dialog, then run this PL/SQL block (you will need to do this each time you connect):

   begin
    dbms_cloud_ai.SET_PROFILE('yourprofilename');
   end;
   /