{"id":3342,"date":"2024-08-06T10:11:08","date_gmt":"2024-08-06T10:11:08","guid":{"rendered":"https:\/\/www.bohort.nl\/?p=3342"},"modified":"2024-08-06T10:39:09","modified_gmt":"2024-08-06T10:39:09","slug":"oracle-select-ai-having-a-conversation-with-your-database","status":"publish","type":"post","link":"https:\/\/www.bohort.nl\/en\/2024\/08\/06\/oracle-select-ai-having-a-conversation-with-your-database\/","title":{"rendered":"Oracle Select AI; Having a Conversation with your Database"},"content":{"rendered":"<p class=\"wp-block-paragraph\">Previously I wrote a post explaining how to setup and use Oracle Select AI. That post showed the basics of this nice feature, but I found that there is more to explore.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-bohort wp-block-embed-bohort\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"lqIRBMMLJs\"><a href=\"https:\/\/www.bohort.nl\/en\/2024\/03\/23\/introducing-oracle-select-ai\/\">Introducing Oracle Select AI<\/a><\/blockquote><iframe class=\"wp-embedded-content lazyload\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Introducing Oracle Select AI&#8221; &#8212; BOHORT\" data-src=\"https:\/\/www.bohort.nl\/2024\/03\/23\/introducing-oracle-select-ai\/embed\/#?secret=0gqUyBTwMC#?secret=lqIRBMMLJs\" data-secret=\"lqIRBMMLJs\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" data-load-mode=\"1\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Last month I visited KScope24 and gained some new knowledge in the session of Oracle\u2019s Mark Hornick (Senior Director Product Management, Oracle Data Science and Machine Learning) who in his session on \u201cGenAI and Oracle Autonomous Database\u201d also touched on Oracle SelectAI.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here is the quick pick for all of those who want to use SelectAI, and just like me missed this interesting detail. In this post I want to add some additional information regarding this feature.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The main pick is the conversational LLM interaction. You can simply ask a question, review the result, and based on that ask a follow up question to refine or the get more information. This can be achieved by adding the \u201cconversation\u201d : \u201ctrue\u201d to the PROFILE. <\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#1E1E1E\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewbox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"BEGIN DBMS_CLOUD_AI.SET_ATTRIBUTE(   profile_name    =&gt; 'openai_gpt35',   attribute_name  =&gt; conversation',   attribute_value =&gt; \u2018TRUE\u2019 );END;\" style=\"color:#D4D4D4;display:none\" aria-label=\"Kopieer\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewbox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki dark-plus\" style=\"background-color: #1E1E1E\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #4FC1FF\">BEGIN<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #4FC1FF\">DBMS_CLOUD_AI<\/span><span style=\"color: #D4D4D4\">.<\/span><span style=\"color: #DCDCAA\">SET_ATTRIBUTE<\/span><span style=\"color: #D4D4D4\">(<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">   <\/span><span style=\"color: #9CDCFE\">profile_name<\/span><span style=\"color: #D4D4D4\">    <\/span><span style=\"color: #569CD6\">=&gt;<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #CE9178\">&#39;openai_gpt35&#39;<\/span><span style=\"color: #D4D4D4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">   <\/span><span style=\"color: #9CDCFE\">attribute_name<\/span><span style=\"color: #D4D4D4\">  <\/span><span style=\"color: #569CD6\">=&gt;<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">conversation<\/span><span style=\"color: #CE9178\">&#39;<\/span><span style=\"color: #F44747\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">   <\/span><span style=\"color: #9CDCFE\">attribute_value<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #569CD6\">=&gt;<\/span><span style=\"color: #D4D4D4\"> \u2018<\/span><span style=\"color: #4FC1FF\">TRUE<\/span><span style=\"color: #D4D4D4\">\u2019<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\"> );<\/span><\/span>\n<span class=\"line\"><span style=\"color: #4FC1FF\">END<\/span><span style=\"color: #D4D4D4\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Note that I used the DBMS_CLOUD_AI.SET_ATTRIBUTE to change my existing profile. Very handy indeed. I do not have to drop and recreate the profile, just add the attribute to it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now we can start a conversation. Lets see which employees work in New York:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"432\" src=\"https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/1-1024x432.png\" alt=\"\" class=\"wp-image-3343\" srcset=\"https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/1-1024x432.png 1024w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/1-300x127.png 300w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/1-768x324.png 768w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/1-18x8.png 18w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/1.png 1246w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">It should now be possible to continue with this result. Lets ask a follow up question, such as the name of this department.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1246\" height=\"526\" data-src=\"https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/2-1024x432.png\" alt=\"\" class=\"wp-image-3344 lazyload\" data-srcset=\"https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/2-1024x432.png 1024w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/2-300x127.png 300w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/2-768x324.png 768w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/2-18x8.png 18w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/2.png 1246w\" data-sizes=\"(max-width: 1246px) 100vw, 1246px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1246px; --smush-placeholder-aspect-ratio: 1246\/526;\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Cool, that seems to work. Lets wrap this up by checking if we can get the salaries of the two employees.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"267\" data-src=\"https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/3-1024x267.png\" alt=\"\" class=\"wp-image-3345 lazyload\" data-srcset=\"https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/3-1024x267.png 1024w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/3-300x78.png 300w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/3-768x200.png 768w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/3-1536x401.png 1536w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/3-18x5.png 18w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2024\/08\/3.png 2016w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/267;\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">There you go. Works like a charm.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Hope this helps you a bit when setting up SelectAI.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>","protected":false},"excerpt":{"rendered":"<p>Previously I wrote a post explaining how to setup and use Oracle Select AI. That post showed the basics of this nice feature, but I found that there is more&#8230;<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[91],"tags":[6,92],"class_list":["post-3342","post","type-post","status-publish","format-standard","hentry","category-ai","tag-oracle","tag-select-ai"],"_links":{"self":[{"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/posts\/3342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/comments?post=3342"}],"version-history":[{"count":4,"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/posts\/3342\/revisions"}],"predecessor-version":[{"id":3352,"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/posts\/3342\/revisions\/3352"}],"wp:attachment":[{"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/media?parent=3342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/categories?post=3342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/tags?post=3342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}