{"id":43223,"date":"2024-07-04T09:57:03","date_gmt":"2024-07-04T07:57:03","guid":{"rendered":"https:\/\/www.schneider.systems\/?p=43223"},"modified":"2024-07-04T09:57:59","modified_gmt":"2024-07-04T07:57:59","slug":"oracle-apex-ai-assistant-ai-aided-coding-in-oracle-database","status":"publish","type":"post","link":"https:\/\/www.schneider.systems\/lu\/oracle-apex-ai-assistant-ai-aided-coding-in-oracle-database\/","title":{"rendered":"Oracle APEX AI Assistant: AI-Aided Coding in Oracle Database"},"content":{"rendered":"<p style=\"text-align: justify;\">Effective June 17, 2024, <strong>Oracle APEX AI Assistant<\/strong> is <strong>part<\/strong> <strong>of<\/strong> the new version of <strong>Oracle APEX<\/strong>, a low-code development platform. With <strong>Oracle APEX AI Assistant<\/strong>, developers now can <strong>create applications<\/strong> by using <strong>natural language prompts<\/strong>. <strong>Oracle APEX<\/strong> is a <span style=\"color: #ff0000;\"><strong>free and fully supported<\/strong><\/span> feature included <strong>with Oracle Database<\/strong> and all Oracle Database services, such as Oracle Autonomous Database.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-43225 aligncenter\" src=\"https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-01-Update-Website-Oracle-APEX-AI-Assistant.png\" alt=\"\" width=\"800\" height=\"514\" srcset=\"https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-01-Update-Website-Oracle-APEX-AI-Assistant.png 800w, https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-01-Update-Website-Oracle-APEX-AI-Assistant-300x193.png 300w, https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-01-Update-Website-Oracle-APEX-AI-Assistant-150x96.png 150w, https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-01-Update-Website-Oracle-APEX-AI-Assistant-768x493.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\"><strong>What is Oracle APEX AI Assistant?<\/strong><\/h2>\n<p style=\"text-align: justify;\">The <strong>Oracle APEX AI Assistant<\/strong> is a new <strong>feature<\/strong> in the <strong>Oracle APEX<\/strong> low-code development platform. It leverages <strong>artificial intelligence<\/strong> (AI) to <strong>simplify<\/strong> and <strong>accelerate<\/strong> the <strong>development<\/strong> of<strong> enterprise applications<\/strong>. <strong>Main capabilities<\/strong> include:<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>Natural Language SQL Generation<\/strong>: Allows developers to create SQL statements using plain language prompts, eliminating the need to remember complex syntax.<\/li>\n<li><strong>Automated Debugging<\/strong>: Identifies and suggests fixes for code bugs, which can be applied with a single click.<\/li>\n<li><strong>Conversational Interfaces<\/strong>: Enables developers to add natural language-based interactions to their applications, enhancing user experience.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-43229 size-large\" src=\"https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Website-Oracle-APEX-AI-Assistant-Joint-Example-800x446.png\" alt=\"\" width=\"800\" height=\"446\" srcset=\"https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Website-Oracle-APEX-AI-Assistant-Joint-Example-800x446.png 800w, https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Website-Oracle-APEX-AI-Assistant-Joint-Example-300x167.png 300w, https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Website-Oracle-APEX-AI-Assistant-Joint-Example-150x84.png 150w, https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Website-Oracle-APEX-AI-Assistant-Joint-Example-768x428.png 768w, https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Website-Oracle-APEX-AI-Assistant-Joint-Example.png 932w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\"><strong>New Features in Oracle APEX 24.1<\/strong><\/h2>\n<p style=\"text-align: justify;\">In <strong>Oracle APEX 24.1<\/strong>, new <strong>AI enhancements<\/strong> include:<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>Natural Language SQL Generation with APEX AI Assistant<\/strong>: Allows developers to create valid SQL statements using natural language prompts. It remembers SQL syntax, automates query writing, explains existing code, and suggests bug fixes that can be applied with a single click. This frees developers from routine coding tasks.<\/li>\n<li><strong>Application Blueprints<\/strong>: Enables the creation of new application blueprints from natural language prompts specifying desired attributes and capabilities. This simplifies the development process, allowing developers to focus on creating unique features rather than underlying code.<\/li>\n<li><strong>Natural Language Interaction with AI<\/strong>: Allows end-users to interact with applications using natural language through an out-of-the-box conversational interface. This provides a richer in-app experience without the need to build generative AI or natural language processing components from scratch.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-43233 aligncenter\" src=\"https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Website-Oracle-APEX-AI-Assistant-SQL.png\" alt=\"\" width=\"800\" height=\"519\" srcset=\"https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Website-Oracle-APEX-AI-Assistant-SQL.png 654w, https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Website-Oracle-APEX-AI-Assistant-SQL-300x194.png 300w, https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Website-Oracle-APEX-AI-Assistant-SQL-150x97.png 150w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\"><strong>About Oracle Database<\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>Oracle<\/strong> <strong>Database<\/strong> (aka. Oracle DB) is a powerful and widely used <strong>relational database management system<\/strong> (RDBMS) developed by Oracle Corporation. A RDBMS is a type of database management system that <strong>organizes data into tables<\/strong>, which are structured in rows and columns. Oracle Database is designed to <strong>efficiently store<\/strong>, <strong>organize<\/strong>, and <strong>retrieve<\/strong> <strong>large amounts of data<\/strong>. It <strong>includes Oracle APEX<\/strong> as a free feature.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-43237 aligncenter\" src=\"https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Oracle-Database-800x391.jpg\" alt=\"\" width=\"800\" height=\"391\" srcset=\"https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Oracle-Database-800x391.jpg 800w, https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Oracle-Database-300x147.jpg 300w, https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Oracle-Database-150x73.jpg 150w, https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Oracle-Database-768x376.jpg 768w, https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Oracle-Database-1536x751.jpg 1536w, https:\/\/www.schneider.systems\/media\/2024\/07\/SCHNEIDER-IT-MANAGEMENT-2024-07-04-Update-Oracle-Database-2048x1002.jpg 2048w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\"><strong>Conclusion<\/strong><\/h2>\n<p style=\"text-align: justify;\">The <strong>Oracle APEX AI Assistant<\/strong> <strong>simplifies application development<\/strong> by <strong>leveraging AI<\/strong> for tasks like SQL generation, debugging, and adding conversational interfaces. These features <strong>enhance<\/strong> <strong>productivity<\/strong> and <strong>allow developers to focus on creating unique application features<\/strong>. As <strong>part of Oracle APEX 24.1<\/strong>, it offers a <strong>powerful toolset<\/strong> for modern developers.<\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\"><strong>Are you interested in Oracle APEX AI Assistant?<\/strong><\/h2>\n<p style=\"text-align: justify;\">You can <strong>access Oracle APEX AI Assistant<\/strong> if you own <strong>Oracle Database<\/strong> instances. <a href=\"https:\/\/www.schneider.systems\/contact\/\">Contact SCHNEIDER IT MANAGEMENT<\/a> to <strong>request a quote<\/strong> for <strong>Oracle Database <\/strong>and <strong>enjoy<\/strong> the <strong>new APEX AI Assistant in Oracle APEX<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-29398 aligncenter\" src=\"https:\/\/www.schneider.systems\/media\/2023\/01\/SCHNEIDER-IT-MANAGEMENT-2023-01-10-Graphics-Office-People-055-progressive.webp\" alt=\"\" width=\"800\" height=\"343\" srcset=\"https:\/\/www.schneider.systems\/media\/2023\/01\/SCHNEIDER-IT-MANAGEMENT-2023-01-10-Graphics-Office-People-055-progressive.webp 800w, https:\/\/www.schneider.systems\/media\/2023\/01\/SCHNEIDER-IT-MANAGEMENT-2023-01-10-Graphics-Office-People-055-progressive-300x129.webp 300w, https:\/\/www.schneider.systems\/media\/2023\/01\/SCHNEIDER-IT-MANAGEMENT-2023-01-10-Graphics-Office-People-055-progressive-150x64.webp 150w, https:\/\/www.schneider.systems\/media\/2023\/01\/SCHNEIDER-IT-MANAGEMENT-2023-01-10-Graphics-Office-People-055-progressive-768x329.webp 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\"><strong>More information<\/strong><\/h2>\n<p style=\"text-align: justify;\">For the <strong>announcement<\/strong>, please visit: <a href=\"https:\/\/www.oracle.com\/be\/news\/announcement\/oracle-apex-ai-assistant-enables-natural-language-based-development-of-enterprise-applications-2024-06-17\/\" rel=\"nofollow\">https:\/\/www.oracle.com\/be\/news\/announcement\/oracle-apex-ai-assistant-enables-natural-language-based-development-of-enterprise-applications-2024-06-17\/<\/a>.<\/p>\n<p style=\"text-align: justify;\">For more on <strong>Oracle<\/strong>, visit <strong>our<\/strong> <strong>Oracle vendor<\/strong> <strong>page<\/strong> at: <a href=\"https:\/\/www.schneider.systems\/software\/oracle\/\">https:\/\/www.schneider.systems\/software\/oracle\/<\/a>.<\/p>\n<p style=\"text-align: justify;\">Please <a href=\"https:\/\/www.schneider.systems\/contact\/\">contact us<\/a> for <strong>expert services<\/strong> on your specific <strong>Oracle<\/strong> requirements and to <strong>request a quote today<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Effective June 17, 2024, Oracle APEX AI Assistant is part of the new version of Oracle APEX, a low-code development platform. With Oracle APEX AI Assistant, developers now can create [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":12001,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[236],"tags":[],"class_list":["post-43223","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-database"],"_links":{"self":[{"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/posts\/43223","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/comments?post=43223"}],"version-history":[{"count":3,"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/posts\/43223\/revisions"}],"predecessor-version":[{"id":43242,"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/posts\/43223\/revisions\/43242"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/media\/12001"}],"wp:attachment":[{"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/media?parent=43223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/categories?post=43223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/tags?post=43223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}