Category: Oracle

Oracle database 23ai (23.9) introduced the UUID() function that returns a 128-bit universal unique identifier, which can be used to generate a primary key value.

Oracle database 23ai (23.9) introduces the ALL keyword to simplify the GROUP BY clause.

In Oracle Database 23ai (23.7) we have the option to materialize the virtual column value. This increases disk space usage, but reduces the need to repeatedly regenerate the values, while allowing it to remain correct through DML operations.

Oracle database 23ai (23.8) gives us multiple layers of control over dynamic statistics in relation to PL/SQL functions. This article demonstrates how that control works.

Oracle database 23ai (23.8) allows greater control over the contents of JSON columns stored in the database using JSON type modifiers.

This article demonstrates pre-authenticated requests using the ORDS_PAR package.

A guide to installation of Apache Tomcat 11 on RHEL and its clones.

Learn how to create a local Yum repository for Oracle Linux 9.

Learn how to create a local Yum repository for Oracle Linux 10.

We can think of Podman as a replacement for Docker, with an almost identical syntax. This article demonstrates how to install Podman on Oracle Linux 10 (OL10).