Latest Articles

RESETTABLE Clause in Oracle AI Database 26ai
The RESETTABLE clause was added in Oracle AI Database 26ai to help prevent ORA-04068 errors when the existing state of a package has been discarded.

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

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

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

QUALIFY Clause in Oracle AI Database 26ai
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.

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/26ai
Oracle database 23ai/26ai gives us variations on the traditional INSERT INTO VALUES and INSERT INTO SELECT syntax. The new variations make code simpler and more readable.

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)