{"id":16681,"date":"2023-03-06T23:20:13","date_gmt":"2023-03-06T23:20:13","guid":{"rendered":"https:\/\/kiusi.com\/?p=16681"},"modified":"2023-03-06T23:20:14","modified_gmt":"2023-03-06T23:20:14","slug":"oracle-apex-y-el-uso-del-chatgpt","status":"publish","type":"post","link":"https:\/\/kiusi.com\/en\/oracle-apex-y-el-uso-del-chatgpt\/","title":{"rendered":"Oracle APEX and the use of ChatGPT"},"content":{"rendered":"<p class=\"wp-block-paragraph\">AI came to help us and today all over the world people are talking about GPT Chat and here I also join this talk!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I want to show you in this post, how I have developed a small application in Oracle APEX that uses the GPT Chat API to get a meal plan and an exercise plan \ud83d\ude0a.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We all at some point see ourselves with the need to go on a diet or improve our lifestyle by eating healthier and exercising, in my case I need it urgently! \ud83d\ude0a Today thanks to AI I want to show you how to call the OpenAI API from APEX to create this very simple demo.<\/p>\n\n\n\n<p class=\"has-link-color wp-elements-ba4e63793e76ace90500e92ceaf57259 wp-block-paragraph\">First of all, I would like to thank a fellow Oracle APEX expert, <a href=\"https:\/\/www.laureston.ca\/2023\/01\/17\/building-a-chatgpt-application-with-oracle-apex-in-record-time\/\" target=\"_blank\" rel=\"noreferrer noopener\">Michelle<\/a>who thanks to your post motivated me to get into this world of GTP and APEX \ud83d\ude0a thanks Michelle!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now, let's see what Chat GPT is. The ChatGPT is a model that is capable of following a prompt and providing a detailed response.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The capabilities of this tool are that:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Remember what the user said earlier in the conversation.<\/li>\n\n\n\n<li>Allows the user to provide follow-up corrections<\/li>\n\n\n\n<li>Trained to reject inappropriate requests<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">As for limitations, the tool warns of the following:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Occasionally may generate incorrect information<\/li>\n\n\n\n<li>Occasionally may produce harmful instructions or biased content<\/li>\n\n\n\n<li>Limited knowledge of the world and events after 2021.<\/li>\n<\/ul>\n\n\n\n<p class=\"has-link-color wp-elements-1cc5aa742e7b36cc833de612c34f3eff wp-block-paragraph\">In order to use the chat we need to create an account at the following link: <a href=\"https:\/\/openai.com\/\">https:\/\/openai.com\/<\/a><\/p>\n\n\n\n<p class=\"has-link-color wp-elements-eab0a65f6335dac8f1e161a66889b3dc wp-block-paragraph\">Once we have the account we go to <a href=\"https:\/\/platform.openai.com\/playground\">https:\/\/platform.openai.com\/playground<\/a> to understand how we can interact with the API.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT1.jpg?ssl=1\"><img data-recalc-dims=\"1\" fetchpriority=\"high\" decoding=\"async\" width=\"750\" height=\"369\" data-attachment-id=\"16682\" data-permalink=\"https:\/\/kiusi.com\/en\/oracle-apex-y-el-uso-del-chatgpt\/gpt1\/\" data-orig-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT1.jpg?fit=2553%2C1257&amp;ssl=1\" data-orig-size=\"2553,1257\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"GPT1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT1.jpg?fit=750%2C369&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT1.jpg?resize=750%2C369&#038;ssl=1\" alt=\"\" class=\"wp-image-16682\" srcset=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT1.jpg?resize=1024%2C504&amp;ssl=1 1024w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT1.jpg?resize=300%2C148&amp;ssl=1 300w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT1.jpg?resize=768%2C378&amp;ssl=1 768w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT1.jpg?resize=1536%2C756&amp;ssl=1 1536w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT1.jpg?resize=2048%2C1008&amp;ssl=1 2048w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT1.jpg?resize=18%2C9&amp;ssl=1 18w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT1.jpg?resize=1200%2C591&amp;ssl=1 1200w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT1.jpg?resize=1568%2C772&amp;ssl=1 1568w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT1.jpg?w=2250&amp;ssl=1 2250w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">En esta pantalla podemos ver un elemento de tipo select list que nos permite cargar distintos ejemplos:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT2.jpg?ssl=1\"><img data-recalc-dims=\"1\" decoding=\"async\" width=\"750\" height=\"532\" data-attachment-id=\"16684\" data-permalink=\"https:\/\/kiusi.com\/en\/oracle-apex-y-el-uso-del-chatgpt\/gpt2\/\" data-orig-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT2.jpg?fit=823%2C584&amp;ssl=1\" data-orig-size=\"823,584\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"GPT2\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT2.jpg?fit=750%2C532&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT2.jpg?resize=750%2C532&#038;ssl=1\" alt=\"\" class=\"wp-image-16684\" srcset=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT2.jpg?w=823&amp;ssl=1 823w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT2.jpg?resize=300%2C213&amp;ssl=1 300w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT2.jpg?resize=768%2C545&amp;ssl=1 768w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT2.jpg?resize=18%2C12&amp;ssl=1 18w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">When loading the example we can see how the API is instructed to perform the translation from English to French and Japanese.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT3.jpg?ssl=1\"><img data-recalc-dims=\"1\" decoding=\"async\" width=\"726\" height=\"401\" data-attachment-id=\"16685\" data-permalink=\"https:\/\/kiusi.com\/en\/oracle-apex-y-el-uso-del-chatgpt\/gpt3\/\" data-orig-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT3.jpg?fit=726%2C401&amp;ssl=1\" data-orig-size=\"726,401\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"GPT3\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT3.jpg?fit=726%2C401&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT3.jpg?resize=726%2C401&#038;ssl=1\" alt=\"\" class=\"wp-image-16685\" srcset=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT3.jpg?w=726&amp;ssl=1 726w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT3.jpg?resize=300%2C166&amp;ssl=1 300w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT3.jpg?resize=18%2C10&amp;ssl=1 18w\" sizes=\"(max-width: 726px) 100vw, 726px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Another example is to explain code:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT4.jpg?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"468\" data-attachment-id=\"16687\" data-permalink=\"https:\/\/kiusi.com\/en\/oracle-apex-y-el-uso-del-chatgpt\/gpt4\/\" data-orig-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT4.jpg?fit=1874%2C1170&amp;ssl=1\" data-orig-size=\"1874,1170\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"GPT4\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT4.jpg?fit=750%2C468&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT4.jpg?resize=750%2C468&#038;ssl=1\" alt=\"\" class=\"wp-image-16687\" srcset=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT4.jpg?resize=1024%2C639&amp;ssl=1 1024w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT4.jpg?resize=300%2C187&amp;ssl=1 300w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT4.jpg?resize=768%2C479&amp;ssl=1 768w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT4.jpg?resize=1536%2C959&amp;ssl=1 1536w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT4.jpg?resize=18%2C12&amp;ssl=1 18w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT4.jpg?resize=1200%2C749&amp;ssl=1 1200w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT4.jpg?resize=1568%2C979&amp;ssl=1 1568w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT4.jpg?w=1874&amp;ssl=1 1874w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">When you click on the Submit button, the explanation of the code begins.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT5.jpg?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"477\" data-attachment-id=\"16688\" data-permalink=\"https:\/\/kiusi.com\/en\/oracle-apex-y-el-uso-del-chatgpt\/gpt5\/\" data-orig-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT5.jpg?fit=960%2C611&amp;ssl=1\" data-orig-size=\"960,611\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"GPT5\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT5.jpg?fit=750%2C477&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT5.jpg?resize=750%2C477&#038;ssl=1\" alt=\"\" class=\"wp-image-16688\" srcset=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT5.jpg?w=960&amp;ssl=1 960w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT5.jpg?resize=300%2C191&amp;ssl=1 300w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT5.jpg?resize=768%2C489&amp;ssl=1 768w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT5.jpg?resize=18%2C12&amp;ssl=1 18w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In the article by <a href=\"https:\/\/www.laureston.ca\/2023\/01\/17\/building-a-chatgpt-application-with-oracle-apex-in-record-time\/\" target=\"_blank\" rel=\"noreferrer noopener\">Michelle<\/a>, she explains very well the basics to keep in mind to generate a better prompt to make a call to OpenAI.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">On the other hand, we should mention that there are different models to use when making an API call.<a href=\"https:\/\/platform.openai.com\/docs\/models\/gpt-3\"><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><a href=\"https:\/\/platform.openai.com\/docs\/models\/gpt-3\">GPT-3 Models<\/a><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">According to the documentation GPT-3 models can understand and generate natural language. They offer four main models with different power levels suitable for different tasks.&nbsp;<strong>Davinci<\/strong> is the most capable and <strong>Ada<\/strong> is the fastest.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>LATEST MODEL<\/strong><\/td><td><strong>DESCRIPTION<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>MAXIMUM REQUEST<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>TRAINING DATA<\/strong><\/td><\/tr><\/thead><tbody><tr><td>texto-davinci-003<\/td><td>The most capable GPT-3 model. It can perform any task that the other models can perform, often with higher quality, longer duration and better instruction tracking. It also supports the insertion of in-text completions.<\/td><td class=\"has-text-align-center\" data-align=\"center\">4,000 tokens<\/td><td class=\"has-text-align-center\" data-align=\"center\">Until June 2021<\/td><\/tr><tr><td>texto-curie-001<\/td><td>Very capable, but faster and lower cost than Davinci.<\/td><td class=\"has-text-align-center\" data-align=\"center\">2,048 tokens<\/td><td class=\"has-text-align-center\" data-align=\"center\">Until October 2019<\/td><\/tr><tr><td>texto-babbage-001<\/td><td>Capable of performing simple, very fast and lower cost tasks.<\/td><td class=\"has-text-align-center\" data-align=\"center\">2,048 tokens<\/td><td class=\"has-text-align-center\" data-align=\"center\">Until October 2019<\/td><\/tr><tr><td>texto-ada-001<\/td><td>Capable of very simple tasks, generally the fastest model of the GPT-3 series and the lowest cost.<\/td><td class=\"has-text-align-center\" data-align=\"center\">2,048 tokens<\/td><td class=\"has-text-align-center\" data-align=\"center\">Until October 2019<\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\">OpenAI Documentation<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Versions prior to GPT-3<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/platform.openai.com\/docs\/models\/davinci\"><strong>Davinci<\/strong><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Davinci is the most capable family of models and can perform any task that the other models can perform and often with less instruction. For applications that require a lot of content understanding, such as summaries for a specific audience and creative content generation, Davinci will produce the best results. These greater capabilities require more computing resources, so Davinci costs more per API call and is not as fast as the other models.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Another area in which Davinci shines is in understanding the intent of the text. Davinci is quite good at solving many types of logic problems and explaining the motives of characters. Davinci has been able to solve some of the most challenging AI problems involving cause and effect.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Good at:&nbsp;<strong>complex intent, cause and effect, audience summary<\/strong><a href=\"https:\/\/platform.openai.com\/docs\/models\/curie\"><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><a href=\"https:\/\/platform.openai.com\/docs\/models\/curie\">Curie<\/a><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Curie is extremely powerful, and very fast. While Davinci is stronger when it comes to parsing complicated text, Curie is quite capable for many nuanced tasks such as classification and sentiment summarization. Curie is also quite good at answering questions and performing Q&amp;A and as a general service chatbot.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Good at:&nbsp;<strong>language translation, complex classification, text sentiment, summarization<\/strong><a href=\"https:\/\/platform.openai.com\/docs\/models\/babbage\"><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><a href=\"https:\/\/platform.openai.com\/docs\/models\/babbage\">Babbage<\/a><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Babbage can perform simple tasks such as simple classification. It is also quite capable when it comes to semantic search that classifies how well documents match search queries.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Good at:&nbsp;<strong>moderate classification, semantic search classification<\/strong><a href=\"https:\/\/platform.openai.com\/docs\/models\/ada\"><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><a href=\"https:\/\/platform.openai.com\/docs\/models\/ada\">Ada<\/a><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ada is usually the fastest model and can perform tasks such as parsing text, correcting addresses, and certain types of sorting tasks that do not require much nuance. Ada's performance can often be improved by providing more context.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">According to the tool, it tells us to use the Davinci model as it is an excellent way to find out what the API is capable of.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To learn more about the API I leave here the link:<\/p>\n\n\n\n<p class=\"has-link-color wp-elements-a67f48b4943543d6578b2ae136eb294d wp-block-paragraph\"><a href=\"https:\/\/platform.openai.com\/docs\/guides\/completion\/prompt-design\">https:\/\/platform.openai.com\/docs\/guides\/completion\/prompt-design<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To be able to use the API in our Oracle APEX application it is necessary first of all to generate our API key. To do this in our profile we access to <strong>View API keys<\/strong>and there we can create a new API Key.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT6.jpg?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"343\" data-attachment-id=\"16692\" data-permalink=\"https:\/\/kiusi.com\/en\/oracle-apex-y-el-uso-del-chatgpt\/gpt6\/\" data-orig-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT6.jpg?fit=1796%2C820&amp;ssl=1\" data-orig-size=\"1796,820\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"GPT6\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT6.jpg?fit=750%2C343&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT6.jpg?resize=750%2C343&#038;ssl=1\" alt=\"\" class=\"wp-image-16692\" srcset=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT6.jpg?resize=1024%2C468&amp;ssl=1 1024w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT6.jpg?resize=300%2C137&amp;ssl=1 300w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT6.jpg?resize=768%2C351&amp;ssl=1 768w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT6.jpg?resize=1536%2C701&amp;ssl=1 1536w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT6.jpg?resize=18%2C8&amp;ssl=1 18w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT6.jpg?resize=1200%2C548&amp;ssl=1 1200w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT6.jpg?resize=1568%2C716&amp;ssl=1 1568w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT6.jpg?w=1796&amp;ssl=1 1796w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example of promp:<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Note: it is better to have a much shorter prompt, since it is easier to get what we really want to get and also we would not have error in the playground when we want to test our prompt. For this demonstration I have made it very simple to have a first approach to this tool. Let's see what the AI recommends us according to the prompt we enter.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\"Act like a nutritionist and create a 3-day diet for me. Create a Detox Diet. The diet should have one serving of protein and two servings of fat and three servings of vegetables and one serving of carbohydrates, for each meal. Prioritize foods that are high in the micronutrients on this list: Iron, Magnesium. Also, I am allergic to or do not like: Salmon. I want you to describe recipes with step-by-step for each meal on a new line. Describe what micronutrients each meal contains.\"<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ingreso al chat GPT:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Y vemos que el chat nos responde con la dieta que pedimos.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT7.jpg?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"976\" data-attachment-id=\"16694\" data-permalink=\"https:\/\/kiusi.com\/en\/oracle-apex-y-el-uso-del-chatgpt\/gpt7\/\" data-orig-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT7.jpg?fit=964%2C1254&amp;ssl=1\" data-orig-size=\"964,1254\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"GPT7\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT7.jpg?fit=750%2C976&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT7.jpg?resize=750%2C976&#038;ssl=1\" alt=\"\" class=\"wp-image-16694\" srcset=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT7.jpg?resize=787%2C1024&amp;ssl=1 787w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT7.jpg?resize=231%2C300&amp;ssl=1 231w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT7.jpg?resize=768%2C999&amp;ssl=1 768w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT7.jpg?resize=9%2C12&amp;ssl=1 9w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT7.jpg?w=964&amp;ssl=1 964w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Oracle APEX con GPTchat<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ahora creamos una p\u00e1gina en APEX para poder seleccionar las opciones. Luego al seleccionar las opciones que deseamos, hacemos clic en el bot\u00f3n <strong>Obtener Mi Plan<\/strong> para realizar la llamada a la API de OpenAI.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT8.jpg?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"371\" data-attachment-id=\"16696\" data-permalink=\"https:\/\/kiusi.com\/en\/oracle-apex-y-el-uso-del-chatgpt\/gpt8\/\" data-orig-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT8.jpg?fit=2542%2C1258&amp;ssl=1\" data-orig-size=\"2542,1258\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;Clari&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;1678106114&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"GPT8\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT8.jpg?fit=750%2C371&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT8.jpg?resize=750%2C371&#038;ssl=1\" alt=\"\" class=\"wp-image-16696\" srcset=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT8.jpg?resize=1024%2C507&amp;ssl=1 1024w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT8.jpg?resize=300%2C148&amp;ssl=1 300w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT8.jpg?resize=768%2C380&amp;ssl=1 768w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT8.jpg?resize=1536%2C760&amp;ssl=1 1536w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT8.jpg?resize=2048%2C1014&amp;ssl=1 2048w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT8.jpg?resize=18%2C9&amp;ssl=1 18w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT8.jpg?resize=1200%2C594&amp;ssl=1 1200w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT8.jpg?resize=1568%2C776&amp;ssl=1 1568w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT8.jpg?w=2250&amp;ssl=1 2250w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Esta p\u00e1gina contiene:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>1 elemento de p\u00e1gina de tipo Select List (Cantidad de D\u00edas).<\/li>\n\n\n\n<li>1 elemento de p\u00e1gina de tipo Radio Group &nbsp;(Tipos de Dietas).<\/li>\n\n\n\n<li>4 elementos de p\u00e1gina de tipo Checkbox &nbsp;(prote\u00ednas, Vegetales, Grasa, y Carbohidratos).<\/li>\n\n\n\n<li>3 elementos de p\u00e1gina de tipo Textarea (Alergias, Incluir Micronutrientes, Comentarios).<\/li>\n\n\n\n<li>2 elementos de p\u00e1gina de tipo Switch (Incluir Informaci\u00f3n Nutricional, Incluir Receta).<\/li>\n\n\n\n<li>1 elemento de tipo Textarea para mostrar el resultado.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Un bot\u00f3n para llamar a la API de OpenAI y otro bot\u00f3n para limpiar la pantalla que simplemente limpia todos los elementos de la pantalla.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">El proceso que utilizamos para darle la indicaci\u00f3n a la API de nuestro prompt es el siguiente:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u201cAct\u00faa como un nutricionista y crea una dieta para m\u00ed de <strong>3<\/strong> d\u00edas. Elabora una <strong>Dieta Detox<\/strong>. La dieta debe tener una porci\u00f3n de prote\u00edna y dos porciones de grasa y tres porciones de vegetales y una porci\u00f3n de carbohidratos, para cada comida. Prioriza las comidas que tienen alto valor de los micronutrientes de esta lista: <strong>Hierro, Magnesio<\/strong>. Adem\u00e1s, soy al\u00e9rgico o no me gusta: <strong>Salm\u00f3n<\/strong>. Quiero que describas recetas con el paso a paso por cada comida en una nueva l\u00ednea. Describa qu\u00e9 micronutrientes contiene cada comida.\u201d<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Lo resaltado en negrita ser\u00edan nuestras opciones. Y las dem\u00e1s opciones se activar\u00e1n en caso que seleccionemos lo elementos para obtener los requerimientos.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">El siguiente c\u00f3digo PL\/SQL lo agregamos como un proceso cuando se hace clic en el bot\u00f3n <strong>Obtener Mi Plan<\/strong>.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>declare\n\nl_prompt varchar2(4000);\n\nbegin\n\n    l_prompt:='Act\u00faa como un nutricionista y crea una dieta para m\u00ed de ' ||:P4_DIAS_SOLICITADOS||' d\u00edas.';\n\n    if :P4_TIPO is not null then   \n        l_prompt:=l_prompt||'Elabora una '||:P4_TIPO||'.';\n    end if;\n\n    if :P4_PROTEINAS = 'Y' then\n        l_prompt:=l_prompt||'La dieta debe tener una porci\u00f3n de prote\u00edna y ';\n    end if;\n\n    if :P4_GRASAS = 'Y' then\n        l_prompt:=l_prompt||'dos porciones de grasas y ';\n    end if;\n\n    if :P4_VEGETALES = 'Y' then\n        l_prompt:=l_prompt||'tres porciones de vegetales y ';\n    end if;\n\n    if :P4_CARBOHIDRATOS  = 'Y' then\n        l_prompt:=l_prompt||'una porci\u00f3n de carbohidratos para cada comida.';\n    end if;\n\n    if :P4_INCLUIR_MICRONUTRIENTES is not null then   \n        l_prompt:=l_prompt||' Prioriza las comidas que tienen alto valor de los micronutrientes de esta lista: '||:P4_INCLUIR_MICRONUTRIENTES||'.';\n    end if;\n\n    if :P4_EVITAR_COMIDA is not null then\n        l_prompt:=l_prompt||'Adem\u00e1s, soy al\u00e9rgico o no me gusta estos alimentos: '||:P4_EVITAR_COMIDA||'.';\n    end if;\n\n    if :P4_INCLUIR_RECETA_DIRECCIONES = 'Y' then\n        l_prompt:=l_prompt||'Quiero que describas recetas con el paso a paso por cada comida en una nueva l\u00ednea.'; \n    else\n        l_prompt:=l_prompt||'No incluya receta para cada comida.'; \n    end if;   \n\n    if :P4_INCLUIR_INFO_NUTRICIONAL = 'Y' then\n        l_prompt:=l_prompt||'Describa qu\u00e9 micronutrientes contiene cada comida.'; \n    end if;\n\n    if :P4_COMENTARIOS is not null then   \n        l_prompt:=l_prompt||'. '||:P4_COMENTARIOS||'.';\n    end if;\n\n    chatgpt_pkg.get_completion(\n        in_parm1 =&gt; l_prompt,\n        out_plan =&gt; :P4_RESPUESTA);\n\nend;<\/code><\/pre>\n\n\n\n<p class=\"has-link-color wp-elements-29547cd592ebce5483d693b771be7a98 wp-block-paragraph\">El paquete que necesitamos para que se realice la llamada, fue creado por Michelle, gracias Michelle por este gran aporte! \ud83d\ude0a Visita su blog <a href=\"https:\/\/www.laureston.ca\/2023\/01\/17\/building-a-chatgpt-application-with-oracle-apex-in-record-time\/\" target=\"_blank\" rel=\"noreferrer noopener\">aqu\u00ed<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Qu\u00e9 interesante lo que puede hacer la IA!, replico lo que ella pregunt\u00f3 para poder hacer la llamada con pl\/sql, me encant\u00f3!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Cu\u00e1l es el c\u00f3digo PL\/SQL requerido para usar apex_web_service.make_rest_request para hacer una llamada a GPT3 usando el modelo text-davinci-003.<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT9bis.jpg?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"923\" data-attachment-id=\"16699\" data-permalink=\"https:\/\/kiusi.com\/en\/oracle-apex-y-el-uso-del-chatgpt\/gpt9bis\/\" data-orig-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT9bis.jpg?fit=1023%2C1259&amp;ssl=1\" data-orig-size=\"1023,1259\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;Clari&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;1677598714&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"GPT9bis\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT9bis.jpg?fit=750%2C923&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT9bis.jpg?resize=750%2C923&#038;ssl=1\" alt=\"\" class=\"wp-image-16699\" srcset=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT9bis.jpg?resize=832%2C1024&amp;ssl=1 832w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT9bis.jpg?resize=244%2C300&amp;ssl=1 244w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT9bis.jpg?resize=768%2C945&amp;ssl=1 768w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT9bis.jpg?resize=10%2C12&amp;ssl=1 10w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT9bis.jpg?w=1023&amp;ssl=1 1023w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Aqu\u00ed est\u00e1 el paquete creado que podemos usar seg\u00fan las especificaciones dadas.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>create or replace PACKAGE \"CHATGPT_PKG\" is \n\/* \nPurpose: PL\/SQL package for OpenAI API \nRemarks: Allows us to post requests to OpenAI API \nWho Date Description \n\u2014\u2014 \u2014\u2014\u2014- \u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014- \nMS 14.1.2023 Created package \n*\/ \nprocedure get_completion ( \nin_parm1 in varchar2, \nout_plan out clob \n); \nend chatgpt_pkg; <\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>create or replace PACKAGE BODY \"CHATGPT_PKG\" is \ng_gpt_api_url constant varchar2(255) := 'https:\/\/api.openai.com\/v1\/completions'; \ng_api_secret constant varchar2(255) := 'API Key'; \n \n \nprocedure get_completion ( \nin_parm1 in varchar2, \nout_plan out clob \n) \nis \nl_result clob; \n \n\/* the parameters in the request could\/should be variables for a more flexible call *\/ \n \nl_request_text varchar2(4000) := '{\"prompt\": \"'||in_parm1||'\", \"model\": \"text-davinci-003\",\"temperature\":0.7,\"max_tokens\":2000}'; \n \nl_json_table clob; \n \nl_status_code number; \n \nbegin \napex_web_service.g_request_headers.delete(); -- clear the header \napex_web_service.g_request_headers(1).name := 'Content-Type'; \napex_web_service.g_request_headers(1).value := 'application\/json'; \napex_web_service.g_request_headers(2).name := 'Authorization'; \napex_web_service.g_request_headers(2).value := 'Bearer '||g_api_secret; \nl_result := apex_web_service.make_rest_request( \np_url =&gt; g_gpt_api_url, \np_http_method =&gt; 'POST', \np_body=&gt;l_request_text \n); \n--Get the status code from the response \nl_status_code := apex_web_service.g_status_code; \n--Raise an exception if the status code is not 200 \nIF l_status_code != 200 THEN \nraise_application_error(-20000, 'La solicitud de API fall\u00f3 con el c\u00f3digo de estado: ' || l_status_code); \nEND IF; \nfor i in (select * from json_table(l_result, '$.choices&#91;*]' \ncolumns ( \nvalue varchar2(4000) path '$.text' \n) \n)) \nloop \nout_plan:=out_plan||i.value; \nend loop; \nend get_completion; \n \nend chatgpt_pkg;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">En la demo tambi\u00e9n he creado una p\u00e1gina para obtener un plan de ejercicios \ud83d\ude0a<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT10bis.jpg?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"365\" data-attachment-id=\"16702\" data-permalink=\"https:\/\/kiusi.com\/en\/oracle-apex-y-el-uso-del-chatgpt\/gpt10bis\/\" data-orig-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT10bis.jpg?fit=1917%2C933&amp;ssl=1\" data-orig-size=\"1917,933\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"GPT10bis\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT10bis.jpg?fit=750%2C365&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT10bis.jpg?resize=750%2C365&#038;ssl=1\" alt=\"\" class=\"wp-image-16702\" srcset=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT10bis.jpg?resize=1024%2C498&amp;ssl=1 1024w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT10bis.jpg?resize=300%2C146&amp;ssl=1 300w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT10bis.jpg?resize=768%2C374&amp;ssl=1 768w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT10bis.jpg?resize=1536%2C748&amp;ssl=1 1536w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT10bis.jpg?resize=18%2C9&amp;ssl=1 18w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT10bis.jpg?resize=1200%2C584&amp;ssl=1 1200w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT10bis.jpg?resize=1568%2C763&amp;ssl=1 1568w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/GPT10bis.jpg?w=1917&amp;ssl=1 1917w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u00a1Te invito a visitar la app y juegues con ella!<\/p>\n\n\n\n<p class=\"has-primary-color has-text-color has-link-color wp-elements-96335d21417b732a8f40fad48fe9c626 wp-block-paragraph\"><a rel=\"noreferrer noopener\" href=\"https:\/\/kiuservice.com\/apex\/r\/prueba\/mi-plan\/login?session=4997172221947\" target=\"_blank\"><strong>App Mi Plan<\/strong><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Usuario: <strong>demogpt<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">contrase\u00f1a: <strong>demogpt2023<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-video wp-block-embed is-type-video is-provider-videopress\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"VideoPress Video Player\" aria-label='VideoPress Video Player' width='750' height='422' src='https:\/\/videopress.com\/embed\/rVSsPTtp?cover=1&amp;posterUrl=https%3A%2F%2Fvideos.files.wordpress.com%2FrVSsPTtp%2Fproyecto-final-16_mp4.scrubthumb.jpg&amp;preloadContent=metadata&amp;useAverageColor=1&amp;hd=0' frameborder='0' allowfullscreen data-resize-to-parent=\"true\" allow='clipboard-write'><\/iframe><script src='https:\/\/v0.wordpress.com\/js\/next\/videopress-iframe.js?m=1674852142'><\/script>\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u00a1Si tienes comentarios o aprendes algo nuevo sobre este nuevo mundo del chatGPT y Oracle APEX por favor escribe en los comentarios!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00a1Hay mucho por aprender todav\u00eda, pero esto es un gran inicio y agradezco a todas las personas que siempre est\u00e1n ayudando y compartiendo lo que aprenden con la comunidad! \u00a1En este caso va mi agradecimiento especial a Michelle por este gran aporte!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">See you next time!<\/p>","protected":false},"excerpt":{"rendered":"<p>\u00a1La IA vino a ayudarnos y hoy en todo el mundo se est\u00e1 hablando del Chat GPT y aqu\u00ed me sumo tambi\u00e9n a esta charla! Quiero mostrarte en este post, c\u00f3mo he desarrollado una peque\u00f1a aplicaci\u00f3n en Oracle APEX que utiliza el API del Chat GPT para obtener un plan de alimentaci\u00f3n y un plan<a class=\"more-link\" href=\"https:\/\/kiusi.com\/en\/oracle-apex-y-el-uso-del-chatgpt\/\">Continue reading <span class=\"screen-reader-text\">&#8220;Oracle APEX y el uso del ChatGPT&#8221;<\/span><\/a><\/p>","protected":false},"author":132749711,"featured_media":16721,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[121913,122116,121887],"tags":[121903,122112,122115,122114,122113,121904],"class_list":["post-16681","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","category-chatgpt","category-oracle-apex","tag-apex","tag-chatgpt","tag-ia","tag-inteligencia-artificial","tag-openai","tag-oracle-apex","entry"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/Oracle-APEXyChatGPT-V3.jpg?fit=2949%2C1735&ssl=1","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paMvMS-4l3","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/16681","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/users\/132749711"}],"replies":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/comments?post=16681"}],"version-history":[{"count":24,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/16681\/revisions"}],"predecessor-version":[{"id":17849,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/16681\/revisions\/17849"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/media\/16721"}],"wp:attachment":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/media?parent=16681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/categories?post=16681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/tags?post=16681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}