During June, the worldwide Oracle ACE community shared tips and tricks, insights, and knowledge in over 300 blog posts. Let us highlight some of them for you to read and enjoy, focusing on 23ai, APEX, OCI, JSON, EPM, Linux, and much more.

Amod Joshi 
Pro
Unleashing the power of Artificial Intelligence in Oracle APEX 24.1

Oracle APEX has been a game-changer in the low-code application development  domain, enabling developers to build robust applications rapidly. Oracle recently released Apex version 24.1 which is loaded with AI features.

Anil Mahadev
Pro
Oracle Developer Tools for Visual Studio – Part 1

Oracle Developer Tools for Visual Studio (ODT for VS) is a suite of free, integrated tools provided by Oracle Corporation to streamline and enhance the development of applications using Oracle databases within Microsoft’s Visual Studio environment.

Arun Raj
Pro
Oracle EPM June 2024 Updates

In Enterprise Data Management, approval policies can be configured with the Management Hierarchy approval method to invite approvers based on a hierarchy of users defined in a Users type application.

Bobby Curtis
Pro
The age of AI with Oracle GoldenGate23ai

Artificial Intelligence (AI) is buzzing in today’s enterprise circles. Let’s briefly examine using AI in data integration, specifically with Oracle GoldenGate. First, what are the benefits of AI in data integration?

Chanaka Dinu Handurugama Yapa
associate
Oracle EBS : Enable Unified Auditing

Database auditing is a critical component of data security, providing vital insights into user activity, changes made to the database, and potential threats lurking within the system.

Dani Schnider
director
Oracle Database 23ai: First Impressions

Oracle 23ai (formerly known as Oracle 23c) is the next long-term release of the Oracle Database. Beginning of May 2024, the general availability was announced.

Federico Venturin
associate
Oracle Analytics Workout: Customer Lifetime Value (CLV) Matrix

Workout Wednesday is a weekly challenge aimed at enhancing skills in Tableau and Power BI through re-creating data-driven visualisations.

Fernando Simon
director
Upgrading to GI 23ai at ExaCC

The 23ai was released last month and was only available at Oracle Cloud deployments and a few places for free edition, nothing besides that. Last year it was also released (focused on the Devs) as a formerly 23c free edition. Fortunately, it was released to be used at ExaCC. So, now we can upgrade Grid Infrastructure (GI) and install the database to play with it.

Jan Květina
Pro
APEX Deployment Tool – Automated patching

Patching is the most significant feature of ADT. You can do a lot of cool things in ADT, but patching is the coolest one. I call this automated patching, because typically I don’t have to intervene and I can deploy a patch without any change.

Jon Dixon
Pro
Generative AI Comes to APEX

With the release of APEX 24.1, Generative AI has come to APEX. Several new AI features are immediately useful to anyone looking to incorporate Generative AI into their APEX Apps.

Louis Moreaux
Pro
How to Easily Download Files in Oracle APEX 24.1

As you may know, Oracle APEX 24.1 is now generally available, and I started to spot the new features. One of them is the improvement in file downloads with a brand new dynamic action, page process type and a PL/SQL API! Let’s take a look at that.

Malik Sikandar Hayat
Pro
Upgrading Oracle APEX in Oracle Cloud Autonomous Database

If you’re using an Oracle Cloud Infrastructure (OCI) account and have Oracle APEX in an Autonomous Database, this article is for you. Whenever a new version of Oracle APEX is released, you might notice a message about Available Updates.

Mathias Magnusson
Pro
23ai Lock-free reservations

An old truth in Oracle and just about all relational databases has been that an update on one row by one session will block an update by another session on the same row. Until the first session commits or rolls back. That is until 23ai.

Michelle Skamene
Pro
Embracing the Future: Oracle APEX’s GenAI Release and Its Impact on Low-Code Development

If you’ve been following the buzz in the Oracle community, you know that Oracle APEX is about to drop its latest version, and they’re promising some jaw-dropping GenAI features.

Miguel Palacios
Pro
Deployment of network communication control in Oracle Cloud Infrastructure with Virtual Cloud Network (VCN)

By leveraging the full capabilities of OCI’s VCN, subnets, and security lists, organizations can achieve a robust, secure, and efficient cloud network infrastructure that meets their specific requirements.

Neil Chandler
director
Time Zones and Oracle Database Patching

I have worked with several clients who rely heavily on time zone data and processing it correctly. If you have columns in your database which are defined as TIMESTAMP WITH TIME ZONE, you need to understand what the relevance is relating to the time zone in your database.

Parthiban Ganesan
associate
How to Create Oracle APEX Workspace

Creating an Oracle APEX workspace on the public instance at (https://apex.oracle.com) is a straightforward process. Below are the step-by-step instructions.

Philipp Salvisberg
Pro
IslandSQL Episode 9: GraphQL, JSON and Flexible Schemas With Duality Views

In the last episode, we looked at some new features in Oracle Database 23.4. The IslandSQL grammar now covers all statements that can contain static DML statements and code in PL/SQL and PL/pgSQL.

Prashant Dixit
Pro
Oracle ACE Program: My Personal Journey

This year has been incredibly successful in terms of professional achievements and personal growth. One of the major milestones of my career was being recognized as an Oracle Ace Pro for 2023-2024.

Roger Cornejo
Pro
Generative AI Inference in OCI:  On-Demand vs Dedicated AI Cluster

Inference in this case is the process of using pre-trained and/or fine-tuned pre-trained Generative AI models to generate output based on your input prompts.

Ron Ekins
director
Working with Oracle Linux 8 and iSCSI

For this blog post I will be using an Oracle Linux 8 server and a Pure Storage FlashArray to demonstrate how block volumes can be presented to an Oracle Linux 8 database server via iSCSI.

Tim Hall
director
Oracle Database : A Bigfile and Shrink Wishlist

A few days ago I mentioned a couple of new features related to bigfile tablespaces in Oracle database 23ai.

Vijayganesh Tirupattur Sivaprakasam
Pro
Installing Oracle 23ai on Windows

Great news for Windows users! Oracle has introduced a free on-premise version of 23ai for Windows.

 

You can find all the ACEs above and many more on the Oracle ACE Directory. Bookmark the Oracle ACE Program blog and come back next month for more updates!