{"id":1477,"date":"2023-07-07T07:03:37","date_gmt":"2023-07-07T05:03:37","guid":{"rendered":"https:\/\/test.contribute.be\/oracle-database-23c-developer-release\/"},"modified":"2025-03-25T17:13:17","modified_gmt":"2025-03-25T15:13:17","slug":"oracle-database-23c-developer-release","status":"publish","type":"post","link":"https:\/\/contribute.be\/en\/oracle-database-23c-developer-release\/","title":{"rendered":"Oracle Database 23c &#8211; developer release"},"content":{"rendered":"\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:15%\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:70%\">\n<p>On the Oracle Base website, you\u2019ll find plenty of articles about the new Oracle Database 23c release: <strong>the developer edition<\/strong>. <br>Finally, this new release brings features that make developers&#8217; lives easier again.<\/p>\n\n\n\n<div style=\"height:75px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Here\u2019s a small list of our favorites from the range of new features:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Automatic PL\/SQL to SQL transpiler<\/strong>: with a simple SQL command: <em>alter session set sql-transpiler = &#8216;ON&#8217;;<\/em> calls to simple PL\/SQL functions\/packages in SQL are resolved by the SQL engine, eliminating the back-and-forth with the PL\/SQL engine. But we wonder, why isn\u2019t this set by default?<\/li>\n\n\n\n<li><strong>SQL Boolean-type:<\/strong> finally. Long available in PL\/SQL, it\u2019s now also available in SQL and as a column type.<\/li>\n\n\n\n<li><strong>DB-DEVELOPER-ROLE<\/strong>: We have mixed feelings. We regularly create schemas for demo, testing, or training purposes. Until now, these were given the default \u201ccreate session\u201d and \u201cresource\u201d roles. The new DB-DEVELOPER-ROLE can replace this. If Oracle systematically expands this role with new features, it could add value. However, as architects, we still want to know who can do what.<\/li>\n\n\n\n<li><strong>Direct joins voor update en delete<\/strong>: today, we solve this with a subquery, but it\u2019s not pretty. From 23c, we can now directly join with the base table. This will certainly improve performance in complex database schemas.<\/li>\n\n\n\n<li><strong>Domains<\/strong>: for large applications aiming to maintain consistency in types and lengths, this can be a huge help.<\/li>\n\n\n\n<li><strong>Aliassen in group by-clause<\/strong>: from now on, we can use the aliases from the SELECT clause in the GROUP BY and HAVING clauses.<\/li>\n\n\n\n<li><strong>Relational duality views<\/strong>: these new view structures allow us to perform CRUD operations on JSON documents using standard SQL CRUD commands: insert, select, update, and delete.<br><\/li>\n\n\n\n<li><strong>\u201cFROM DUAL\u201d<\/strong>: no Longer Needed! For simple queries or queries that add static data, we can now drop the \u201cFROM DUAL\u201d clause. Behind the scenes, it\u2019s still added, but it saves us from some typing. It will feel strange at first, though.<\/li>\n\n\n\n<li><strong>Table values constructor<\/strong>: this is even more interesting than \u201cFROM DUAL.\u201d It allows you to add fixed data as a table to the WITH, FROM, INSERT, and MERGE clauses. Perfect for adding LOV or status lists.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:75px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><a href=\"https:\/\/oracle-base.com\/articles\/23c\" target=\"_blank\" rel=\"noreferrer noopener\">Here<\/a> you can find this and many other articles about the new database release for developers.<\/p>\n\n\n\n<p>If you have any questions or want to learn more about how the Oracle Database can help you, feel free to <a href=\"https:\/\/test.contribute.be\/en\/contact\/\" target=\"_blank\" rel=\"noreferrer noopener\">contact<\/a> us.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:15%\"><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>The new Oracle Database 23c developer release introduces features that will make developers\u2019 lives easier.<\/p>\n","protected":false},"author":2,"featured_media":1361,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[41],"tags":[],"class_list":["post-1477","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news"],"acf":[],"_links":{"self":[{"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/posts\/1477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/comments?post=1477"}],"version-history":[{"count":4,"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/posts\/1477\/revisions"}],"predecessor-version":[{"id":1594,"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/posts\/1477\/revisions\/1594"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/media\/1361"}],"wp:attachment":[{"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/media?parent=1477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/categories?post=1477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/contribute.be\/en\/wp-json\/wp\/v2\/tags?post=1477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}