{"id":44191,"date":"2024-01-03T16:16:16","date_gmt":"2024-01-03T10:46:16","guid":{"rendered":"https:\/\/www.oneclickitsolution.com\/blog\/?p=44191"},"modified":"2024-09-06T11:37:55","modified_gmt":"2024-09-06T06:07:55","slug":"oracle-database-21c-takes-on-cloud-with-apex","status":"publish","type":"post","link":"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex","title":{"rendered":"Oracle Database 21C Takes on Cloud with APEX"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p>\u201cCloud-first\u201d, \u201cInnovative\u201d, \u201cPowerful\u201d, \u201cAdapted for <strong><a href=\"https:\/\/www.oneclickitsolution.com\/blog\/machine-learning-and-its-impact-in-different-industries\/\" target=\"_blank\" rel=\"noreferrer noopener\">machine learning<\/a><\/strong>\u201d. It is in these terms that Oracle described its new version: Oracle Database 21c.<\/p>\n\n\n\n<p>The famous database management system (DBMS) contains no less than 200 innovations and includes an unprecedented evolution of its application development tool called APEX and available on the cloud. Oracle&#8217;s stated goal is to consolidate its leadership position by providing the most powerful converged database engine in the world while adapting to changes in the IT field. Did the firm achieve its objective with this version?<\/p>\n\n\n\n<p>Find out what&#8217;s new in Oracle Database 21c and Apex.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.oneclickitsolution.com\/contact-us\/\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/www.oneclickitsolution.com\/blog\/wp-content\/uploads\/2022\/01\/hire-dedicated-developers-1.png\" alt=\"hire dedicated developers\" class=\"wp-image-47848\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-oracle-database-21c-a-version-focused-on-multi-data\">Oracle Database 21c, a Version Focused on Multi Data<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-native-support-for-json\">1. Native Support for JSON<\/h3>\n\n\n\n<p>Oracle supports since its variant 12c JSON data by saving it in the form of VARCHAR2 or LOB files (CLOB or BLOB). Users can also query JSON documents using standard SQL queries.<\/p>\n\n\n\n<p>But version 21c goes further by integrating a native type: &#8220;JSON&#8221;. Now JSON data is stored in an internal binary format which makes it much more direct to access. Read and update operations are up to 5 times faster and up to 30 times faster for editing very large JSON files.<\/p>\n\n\n\n<p>Example of creating a new database table that includes data of type:<\/p>\n\n\n\n<p>JSONCREATE TABLE j_order ( id INTEGER PRIMARY KEY,po_doc JSON) ;<\/p>\n\n\n\n<p>Oracle Database 21c also includes a new JSON_TRANSFORM function that makes it easy to update and delete multiple data in a document, in a single operation.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"markup\" class=\"language-markup\">UPDATE j_order SET po_doc = JSON_TRANSFORM( po_doc, SET \u00ab $. address.city \u00bb = \u00ab Paris \u00bb , REMOVE \u00bb $. phones [*]?(@.type == \u00ab portable \u00bb)' )WHERE id = 777;<\/code><\/pre>\n\n\n\n<p>Finally, Oracle added support for the JSON data type to software packages and utilities such as Datapump and GoldenGate.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-2-execution-of-javascript-code-in-the-database\">2. Execution of JavaScript Code in the Database<\/h3>\n\n\n\n<p>Another long-awaited new feature of Oracle Database 21c is the ability to run JavaScript code directly in the database. With the DBMS_MLE package, data of type JavaScript is automatically mapped to Oracle data types and vice versa. It is now easy to exchange data transparently between PL \/ SQL and JavaScript. The JavaScript code itself can perform PL \/ SQL and SQL commands via an integrated JavaScript module.<\/p>\n\n\n\n<p><strong>Example code to run JavaScript in an SQL query:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"markup\" class=\"language-markup\">DECLARE ctx\nDBMS_MLE.context_handle_t : = DBMS_MLE.create_context ();\nBEGIN\nDBMS_MLE.eval (ctx, 'JAVASCRIPT', q'~console.log(\"Hello world !\");\nDBMS_MLE.drop_context(ctx);\nEND;<\/code><\/pre>\n\n\n\n<p>JavaScript is evaluated in a database session and is always bound to a context that encapsulates the state of the application. This context is then deleted (drop_context) as soon as it is no longer needed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-creation-of-a-new-machine-learning-tool-automl\">3. Creation of a New Machine Learning Tool: AutoML<\/h3>\n\n\n\n<p>Already in its previous versions, Oracle integrated machine learning algorithms that allowed the power of its DBMS to be used to create predictive models. More than 30 machine learning algorithms could run directly on the <a href=\"https:\/\/www.oneclickitsolution.com\/blog\/getting-started-with-core-data-fundamentals\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>data contained in the database<\/strong><\/a>. Oracle Database 21c adds support for MSET-SPRT, XGBoost, and Adam Solver algorithms (for neural networks).<\/p>\n\n\n\n<p>But above all, this new version marks the arrival of AutoML, a tool that complements the existing R and SQL interfaces. Now, scientists, data scientists, and analysts will be able to provide Python machine learning interfaces to the database. AutoML also simplifies the development of predictive machine learning models by automating the selection of features and facilitating the adjustments needed to build accurate models.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-4-protect-this-data-with-oracle-blockchain-tables\">4. Protect this Data with Oracle Blockchain Tables<\/h3>\n\n\n\n<p>Another fundamental innovation of this 21c version is the appearance of <strong><a href=\"https:\/\/www.oneclickitsolution.com\/services\/blockchain-development\/\" target=\"_blank\" rel=\"noreferrer noopener\">Blockchain<\/a><\/strong> tables. These tables operate on an essential principle for data protection: immutability. Each row of data inserted is hashed cryptographically when it is added to the database. The content can no longer be edited or deleted.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<div class=\"box_section_read\">\n<h3>Read More: <a href=\"https:\/\/www.oneclickitsolution.com\/blog\/best-practices-for-securing-data-and-data-migration-in-the-cloud\/\" target=\"_blank\" rel=\"noreferrer noopener\">7 Best Practices for Securing Data and Data Migration in the Cloud<\/a><\/h3>\n<\/div>\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-5-the-revival-of-the-oracle-apex-application-development-service\">5. The Revival of the Oracle APEX Application Development Service<\/h3>\n\n\n\n<p>Oracle Application Express available as a cloud service<\/p>\n\n\n\n<p>Oracle has been providing <strong><a href=\"https:\/\/www.oneclickitsolution.com\/hire-dedicated-developers\/\" target=\"_blank\" rel=\"noreferrer noopener\">developers<\/a><\/strong> with the ability to quickly program applications for over 15 years. The Oracle Application Express integrated development environment, better known as &#8220;Oracle Apex&#8221;, is a low-code platform, that is, a platform requiring minimal coding, which makes it possible to easily create and deploy applications.<\/p>\n\n\n\n<p>APEX is now delivered as a <strong><a href=\"https:\/\/www.oneclickitsolution.com\/services\/native-app-development\/\" target=\"_blank\" rel=\"noreferrer noopener\">cloud-native application development<\/a><\/strong> service linked to a database in Oracle Cloud Infrastructure (OCI). Accessible directly from a browser, the IDE now includes a base of 1 to 500 terabytes that run on a single to 128 OCPUs (an Oracle unit of measure, defined as the CPU capacity equivalent of a core Intel Xeon processor physics with hyper-threading).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-6-more-use-cases\">6. More Use Cases<\/h3>\n\n\n\n<p>According to its creators, Oracle APEX now provides developers with everything they need to build complex applications nearly 40 times faster.<\/p>\n\n\n\n<p>Andrew Mendelsohn, vice president of Oracle, said, \u201cAPEX is powerful enough to create the vast majority of business software. Building data-driven applications with traditional encoding should now be the exception rather than the rule.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.oneclickitsolution.com\/contact-us\/\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/www.oneclickitsolution.com\/blog\/wp-content\/uploads\/2021\/12\/web-development-framework.png\" alt=\"web development framework\" class=\"wp-image-47088\"\/><\/a><\/figure>\n\n\n\n<p>In addition, with APEX, users can develop and install their programs on all platforms with Oracle DBMS including in the cloud.<\/p>\n\n\n\n<p>Finally, the software created in APEX integrates different types of data (for example relational, JSON, and spatial). This same software can use variables from various sources within particular the synchronization of data from API REST.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction \u201cCloud-first\u201d, \u201cInnovative\u201d, \u201cPowerful\u201d, \u201cAdapted for machine learning\u201d. It is in these terms that Oracle described its new version: Oracle Database 21c. The famous database management system (DBMS) contains no less than 200 innovations and includes an unprecedented evolution of its application development tool called APEX and available on the cloud. Oracle&#8217;s stated goal is &hellip;<\/p>\n","protected":false},"author":1,"featured_media":54159,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,784],"tags":[931,930],"class_list":["post-44191","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","category-web-application","tag-database-21c","tag-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.2.1 (Yoast SEO v24.8.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle Database 21C Takes on Cloud with APEX<\/title>\n<meta name=\"description\" content=\"Its low-code apex application Development service and announced the availability of oracle database 21c on apex cloud.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database 21C Takes on Cloud with APEX\" \/>\n<meta property=\"og:description\" content=\"Its low-code apex application Development service and announced the availability of oracle database 21c on apex cloud.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex\" \/>\n<meta property=\"og:site_name\" content=\"OneClick IT Consultancy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/oneclickconsultancy\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-03T10:46:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-06T06:07:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.oneclickitsolution.com\/blog\/wp-content\/uploads\/2021\/02\/Oracle-Database-21C-with-Cloud-Apex.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"OneClick IT Consultancy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@OneclickIT\" \/>\n<meta name=\"twitter:site\" content=\"@OneclickIT\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"OneClick IT Consultancy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Database 21C Takes on Cloud with APEX","description":"Its low-code apex application Development service and announced the availability of oracle database 21c on apex cloud.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex","og_locale":"en_US","og_type":"article","og_title":"Oracle Database 21C Takes on Cloud with APEX","og_description":"Its low-code apex application Development service and announced the availability of oracle database 21c on apex cloud.","og_url":"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex","og_site_name":"OneClick IT Consultancy","article_publisher":"https:\/\/www.facebook.com\/oneclickconsultancy","article_published_time":"2024-01-03T10:46:16+00:00","article_modified_time":"2024-09-06T06:07:55+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.oneclickitsolution.com\/blog\/wp-content\/uploads\/2021\/02\/Oracle-Database-21C-with-Cloud-Apex.png","type":"image\/png"}],"author":"OneClick IT Consultancy","twitter_card":"summary_large_image","twitter_creator":"@OneclickIT","twitter_site":"@OneclickIT","twitter_misc":{"Written by":"OneClick IT Consultancy","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex#article","isPartOf":{"@id":"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex"},"author":{"name":"OneClick IT Consultancy","@id":"https:\/\/www.oneclickitsolution.com\/blog\/#\/schema\/person\/c2616c0a433427a79a96fe5ca2b34ec3"},"headline":"Oracle Database 21C Takes on Cloud with APEX","datePublished":"2024-01-03T10:46:16+00:00","dateModified":"2024-09-06T06:07:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex"},"wordCount":821,"commentCount":0,"publisher":{"@id":"https:\/\/www.oneclickitsolution.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex#primaryimage"},"thumbnailUrl":"https:\/\/www.oneclickitsolution.com\/blog\/wp-content\/uploads\/2021\/02\/Oracle-Database-21C-with-Cloud-Apex.png","keywords":["Database 21C","Oracle"],"articleSection":["Technology","Web Application"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex","url":"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex","name":"Oracle Database 21C Takes on Cloud with APEX","isPartOf":{"@id":"https:\/\/www.oneclickitsolution.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex#primaryimage"},"image":{"@id":"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex#primaryimage"},"thumbnailUrl":"https:\/\/www.oneclickitsolution.com\/blog\/wp-content\/uploads\/2021\/02\/Oracle-Database-21C-with-Cloud-Apex.png","datePublished":"2024-01-03T10:46:16+00:00","dateModified":"2024-09-06T06:07:55+00:00","description":"Its low-code apex application Development service and announced the availability of oracle database 21c on apex cloud.","breadcrumb":{"@id":"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex#primaryimage","url":"https:\/\/www.oneclickitsolution.com\/blog\/wp-content\/uploads\/2021\/02\/Oracle-Database-21C-with-Cloud-Apex.png","contentUrl":"https:\/\/www.oneclickitsolution.com\/blog\/wp-content\/uploads\/2021\/02\/Oracle-Database-21C-with-Cloud-Apex.png","width":1200,"height":628,"caption":"Oracle Database 21C Takes on Cloud with APEX"},{"@type":"BreadcrumbList","@id":"https:\/\/www.oneclickitsolution.com\/blog\/oracle-database-21c-takes-on-cloud-with-apex#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/www.oneclickitsolution.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Database 21C Takes on Cloud with APEX"}]},{"@type":"WebSite","@id":"https:\/\/www.oneclickitsolution.com\/blog\/#website","url":"https:\/\/www.oneclickitsolution.com\/blog\/","name":"OneClick IT Consultancy","description":"We Build Brands from Ideas","publisher":{"@id":"https:\/\/www.oneclickitsolution.com\/blog\/#organization"},"alternateName":"OneClick IT Solution","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.oneclickitsolution.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.oneclickitsolution.com\/blog\/#organization","name":"OneClick IT Consultancy","alternateName":"OneClick IT Solution","url":"https:\/\/www.oneclickitsolution.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.oneclickitsolution.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.oneclickitsolution.com\/blog\/wp-content\/uploads\/2022\/10\/oneclick-official-logo.png","contentUrl":"https:\/\/www.oneclickitsolution.com\/blog\/wp-content\/uploads\/2022\/10\/oneclick-official-logo.png","width":100,"height":100,"caption":"OneClick IT Consultancy"},"image":{"@id":"https:\/\/www.oneclickitsolution.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/oneclickconsultancy","https:\/\/x.com\/OneclickIT","https:\/\/www.instagram.com\/oneclick.it.consultancy\/","https:\/\/www.linkedin.com\/company\/one-click-it-consultancy\/","https:\/\/www.pinterest.com\/oneclickitconsultancy\/","https:\/\/www.youtube.com\/channel\/UCsEG6aiwOwvYrcZxMoP5xjg","https:\/\/oneclickit.tumblr.com\/","https:\/\/dribbble.com\/oneclickitconsultancy"]},{"@type":"Person","@id":"https:\/\/www.oneclickitsolution.com\/blog\/#\/schema\/person\/c2616c0a433427a79a96fe5ca2b34ec3","name":"OneClick IT Consultancy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.oneclickitsolution.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8169ffe1b63da548d77fb666e94f1aba?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8169ffe1b63da548d77fb666e94f1aba?s=96&d=mm&r=g","caption":"OneClick IT Consultancy"},"description":"OneClick IT Consultancy is the best custom software development company based in India &amp; USA with expertise in BLE, travel, mobile, and web development. With nearly a decade\u2019s experience, we use best practices and development standards to deliver high-performance applications, focused on the user experience.","sameAs":["https:\/\/www.oneclickitsolution.com\/blog\/"],"jobTitle":"Founder","url":"https:\/\/www.oneclickitsolution.com\/blog\/author\/oneclick"}]}},"_links":{"self":[{"href":"https:\/\/www.oneclickitsolution.com\/blog\/wp-json\/wp\/v2\/posts\/44191"}],"collection":[{"href":"https:\/\/www.oneclickitsolution.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oneclickitsolution.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oneclickitsolution.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oneclickitsolution.com\/blog\/wp-json\/wp\/v2\/comments?post=44191"}],"version-history":[{"count":0,"href":"https:\/\/www.oneclickitsolution.com\/blog\/wp-json\/wp\/v2\/posts\/44191\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.oneclickitsolution.com\/blog\/wp-json\/wp\/v2\/media\/54159"}],"wp:attachment":[{"href":"https:\/\/www.oneclickitsolution.com\/blog\/wp-json\/wp\/v2\/media?parent=44191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oneclickitsolution.com\/blog\/wp-json\/wp\/v2\/categories?post=44191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oneclickitsolution.com\/blog\/wp-json\/wp\/v2\/tags?post=44191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}