Latest Articles

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

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

Non-Positional INSERT INTO SET and INSERT INTO BY NAME Clauses in Oracle Database 23ai
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.

UUID() Function in Oracle Database 23ai
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.

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

Materialized Virtual Columns (Expression Columns) in Oracle Database 23ai
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.

Dynamic Statistics for PL/SQL Functions in Oracle Database 23ai
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.

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

Latest Videos

Check out my YouTube channel here.

• Data Pump LOGTIME
• Data Pump Checksums in Oracle Database 21c
• RANK and DENSE_RANK Aggregate Functions
• SQLcl : Data Pump (Part 2)

Quick Links

• SQL for Beginners
• Multitenant Articles
• ORDS Articles
• JSON Articles
• Docker/Container Articles
• Writing Tips
• Public Speaking Tips
• Learning New Things
• What Employers Want
• Why Automation Matters

You can follow me on these networks:

• Twitter/X (@oraclebase)
• LinkedIn
• YouTube
• Facebook
• GitHub
• Mastodon (@oraclebase@techhub.social)
• Bluesky (@oraclebase.bsky.social)
• Threads
• Linktree

Oracle Documentation

12cR1, 12cR2, 18c, 19c, 21c, 23ai, 26ai
ORDS 22, ORDS 23, ORDS 24, ORDS 25
APEX 22.1, APEX 22.2, APEX 23.1, APEX Old Releases
ADW, ATP
EM 13c, Middleware, VirtualBox

Oracle Resources

Oracle Developer Community, Technology Network, Oracle Support, Oracle Certification, Oracle Magazine, Ask Tom, Products, Downloads, Documentation, Forums, VirtualBox, VirtualBox Developer VMs, CPUs/PSUs/BPs/RUs/RURs, ORAdiff,
Release Schedule of Current Database Releases (Doc ID 742060.1)