Top 11 recommendations for the week – Oracle ACEs Edition

In the past week, Oracle ACEs from all around the world shared insights and knowledge in over 50 blog posts and articles. We have selected 11 of them for you to read and enjoy, focusing on JSON, MySQL Heatwave, APEX, OCI, Java and more.

• Alli Pierre Yotti

  

  : Ensuring JSON Structure and Typing with JSON Schema in Oracle 23c

JSON (JavaScript Object Notation) has gained significant popularity as a data format for representing structured information due to its simplicity and compatibility with various programming languages. With the introduction of Oracle 23c, Oracle Database now provides built-in support for JSON Schema validation, enabling users to ensure the integrity and correctness of JSON documents stored in database tables. In this blog post, we will delve into how you can leverage JSON Schema in Oracle 23c to enforce JSON structure, define data types, specify optional or required fields, and validate JSON documents during table creation.

• Bobby Curtis

  

  : MySQL Heatwave: ML Basic

Machine Learning (ML) and Artificial Intelligence (AI) is all the new, hot, shiny thing in the industry today.  Everyone is looking for ways to make a business decision quickly and accurately.  With this goal in mind, software manufactures are attempting to give access to machine learning capabilities easier within their respective databases and cloud offerings.

• Chanaka Dinu Handurugama Yapa

  

  :  Oracle Base Database patching to 19.17 using DBCLI

 Cloud platforms are booming and many organizations are planning on a cloud journey to get a competitive advantage.  The cloud market is vast, with a diverse selection of services. It’s not easy to select a suitable cloud platform for an organization.  There are certain criteria you need to consider when selecting a platform. 

• Deepak Vohra

  

  : A Comprehensive Guide to Java’s New Feature: Pattern Matching for Switch

A switch statement is a control-flow statement that was originally designed to be a short-form alternative to the if-else if-else control-flow statement for certain use cases that involved multiple possible execution paths based on what a given expression evaluates to.

• Johannes Michler 

  

  :  Oracle OCI Load Balancer with Lets Encrypt (free) SSL certificates

 Nowadays, all web traffic through the internet should be encrypted. For this to work, SSL certificates are required. These can be bought from commercial Certificate Authorities. Since around 2016, certificates are also provided for free by the nonprofit Certificate Authority Let’s Encrypt. There are various tools to create these certificates, also with Oracle OCI, however, they usually require dedicated web servers for verification with a HTTP challenge or they need control over DNS. This blog post will show a very lightweight alternative using OCI Load Balancer, OCI Object Storage as well as the OCI Certificate Service.

• Jonathan Dixon

  

  : Oracle APEX Application Search

In Oracle APEX Version 22.2, the APEX development team introduced a new search method called Application Search. With a dedicated Search Region type and multiple places to source data from, Application Search has put an end to homegrown search solutions for APEX.

• Louis Moreaux

  

  : Oracle APEX 23.1 – TinyMCE and image upload

As you may know now, if you have read my previous blog post, I am a big fan of the Rich Text Editor (RTE) item. I published several blog posts on implementing cool features with CKEditor5 like image upload, mention or word counters. But in the latest APEX release 23.1, the library behind the RTE has changed and I already welcome TinyMCE in a previous post. Today I wanted to see how to implement the image upload feature within an Oracle APEX application with this new library.

• Matt Mulvaney

  

  : Achieving a SaaS Model for multi-tenant APEX Applications using Oracle IAM Domains

In this Blog, we are going to create two tables:

•     tenants
•     t_products

An APEX application will be built on the t_products table. We will create two FREE Oracle Cloud IAM Domains representing two Tenants (aka. Customer user sets).

• Roger Cornejo

  

  : Optimizing Oracle Applications – Harnessing SQL Profiles and SQL Plan Baselines

In the complex world of Oracle database applications, achieving optimal performance and stability is a constant challenge. Fortunately, Oracle provides powerful tools like SQL Profiles and SQL Plan Baselines that can significantly enhance performance optimization efforts.

• Stefan Oehrli

  

  : Unleash the Power of the User Home SQLNet Config

A crucial functionality of databases is that they are accessible via a network. This also applies to Oracle databases, where network access is controlled by the Oracle Net Service components. The two files sqlnet.ora and tnsnames.ora belong to the key configuration files and can be used on both the client machines and the database server. While you may be familiar with the essential configuration files, did you know that there’s a hidden path to unlock greater flexibility in Oracle Net Service?

• Tim Hall

  

  : Hybrid Read-Only Mode for PDBs in Oracle Database 23c

Oracle 23c allows us to open PDBs in hybrid read-only mode. This allows common users to work in read-write mode, while local users and common application users are restricted to read-only mode.