Oracle

This article provides a pictorial guide for performing a basic server installation of Fedora 43 (F43).

This article describes the installation of Oracle Database 19c 64-bit on Fedora 43 (F43).

This article describes the installation of Oracle Database 21c 64-bit on Fedora 43 (F43).

The QUALIFY clause is to analytic functions what the HAVING clause is to GROUP BY. This article demonstrates how to use the QUALIFY clause introduced in Oracle AI Database 26ai.

This article describes the RPM installation of Oracle AI Database 26ai Free 64-bit on Oracle Linux 8 (OL8) 64-bit.

This article describes the RPM installation of Oracle AI Database 26ai Free 64-bit on Oracle Linux 9 (OL9) 64-bit.

Oracle database 23ai gives us variations on the traditional INSERT INTO VALUES and INSERT INTO SELECT syntax. The new variations make code simpler and more readable.

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/26ai (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.