インモビインモビ

BEGIN
    DBMS_CLOUD_AI.CREATE_PROFILE(
          'GENAI_COHERE_COMMAND_R',
          '{
               "provider": "oci",
               "credential_name": "OCI_GENAI_CRED",
               "model":"cohere.command-r-08-2024",
               "oci_apiformat":"COHERE",
               "object_list": [
                       {"owner": "SH", "name": "COUNTRIES"}
               ]
           }'
       );
END;

EXEC DBMS_CLOUD_AI.SET_PROFILE('GENAI_COHERE_COMMAND_R');

select ai 顧客は全部で何人いますか;

   TotalCustomers
_________________
               23

Elapsed: 00:00:01.192

select ai 顧客は全部で何人いますか;

   TotalCustomers
_________________
               23

Elapsed: 00:00:00.015

select ai 顧客は全部で何人いますか。;

   TotalCustomers
_________________
               23

Elapsed: 00:00:01.053

select ai 顧客は全部で何人いますか。;

   TotalCustomers
_________________
               23

Elapsed: 00:00:00.006

SELECT DBMS_CLOUD_AI.GENERATE(prompt       => '顧客は全部で何人いますか',
                              profile_name => 'GENAI_COHERE_COMMAND_R',
                              action       => 'runsql')
FROM dual;

DBMS_CLOUD_AI.GENERATE(PROMPT=>'顧客は全部で何人いますか',PROFILE_NAME=>'GENAI_COHERE_COMMAND_R',ACTION=>'RUNSQL')
_________________________________________________________________________________________________________
[
  {
    "Total Customers" : 23
  }
]

Elapsed: 00:00:01.123

DBMS_CLOUD_AI.GENERATE(PROMPT=>'顧客は全部で何人いますか',PROFILE_NAME=>'GENAI_COHERE_COMMAND_R',ACTION=>'RUNSQL')
_________________________________________________________________________________________________________
[
  {
    "Total Customers" : 23
  }
]

Elapsed: 00:00:01.007

select ai runsql drop table customersを実行して;

RESPONSE
_______________________________________________________________________________________________
Sorry, unfortunately a valid SELECT statement could not be generated for your natural language prompt. Here is some more information to help you further:

申し訳ありませんが、私はデータベース管理システムではなく、言語モデルです。そのため、データベース操作やテーブルの削除は実行できません。

データベースの管理やテーブルの操作は、適切な権限とデータベース管理システムを使用して行う必要があります。データベース管理者や開発者に相談して、必要な操作を実行してもらってください。

select ai showsql delete customers;

RESPONSE
_______________________________________________________________________________________________
Sorry, unfortunately a valid SELECT statement could not be generated for your natural language prompt. Here is some more information to help you further:

I'm sorry, but as an AI language model, I am unable to perform tasks outside of text generation and manipulation. Deleting data, especially sensitive information like customer records, is a serious matter and should be handled with great care and responsibility.

If you require assistance with data management or have specific questions related to customer data deletion, I recommend consulting with a professional data manager or a legal expert who can guide you through the appropriate processes and ensure compliance with relevant data protection regulations.

-- ユーザー情報の取得
v_user := SYS_CONTEXT('USERENV', 'SESSION_USER');

-- ユーザー情報からコードを取得
SELECT CODE
INTO v_code
FROM XX
WHERE USER_ID = v_user;

-- 取得したコードを質問文に加えてプロンプトを作成
v_prompt := 'コードは' || v_code || '、'|| '製品Xの在庫数を教えてください';

-- SELECT AI実行
SELECT DBMS_CLOUD_AI.GENERATE(
               prompt       => v_prompt,
               profile_name => 'profile_name',
               action       => 'showsql'
           )
FROM dual;

SELECT inventory_cnt
FROM STOCKS
WHERE code = (v_code) AND product_name = 'X'