-- Select AI profile instructions contain only common SQL-generation guidance.
-- Game target routing and execution policy are supplied at runtime by
-- SG_GAME_QUERY_PLAN; they do not belong in the profile-wide prompt.

BEGIN
  DBMS_CLOUD_AI.SET_ATTRIBUTE(
    profile_name => 'SGMP_POC_OCI_GPT54MINI',
    attribute_name => 'additional_instructions',
    attribute_value => q'~Generate Oracle SQL only for the listed approved objects. Do not reference external tables. Use English aliases only. Use database comments and annotations as the source of business rules.

~'
  );
END;
/

SELECT attribute_name, attribute_value
  FROM user_cloud_ai_profile_attributes
 WHERE profile_name = 'SGMP_POC_OCI_GPT54MINI'
   AND attribute_name = 'additional_instructions';
