Latest Articles

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.

Oracle REST Data Services (ORDS) : Pre-Authenticated Requests
This article demonstrates pre-authenticated requests using the ORDS_PAR package.

Apache Tomcat 11 Installation on Linux (RHEL and clones)
A guide to installation of Apache Tomcat 11 on RHEL and its clones.

 

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

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

Podman : Install Podman on Oracle Linux 10 (OL10)
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).

Oracle Database 19c Installation On Oracle Linux 10 (OL10)
This article describes the installation of Oracle Database 19c 64-bit on Oracle Linux 10 (OL10) 64-bit.

Oracle Linux 10 (OL10) Installation
This article provides a pictorial guide for performing a basic server installation of Oracle Linux 10 (OL10).

Oracle Application Express (APEX) : Manage Web Credentials From the Command Line
This article describes how to manage APEX web credentials from the command line.

Oracle REST Data Services (ORDS) : Authentication Enhancements (ORDS_SECURITY and ORDS_SECURITY_ADMIN Packages)
This article demonstrates OAuth setup using the ORDS_SECURITY and ORDS_SECURITY_ADMIN packages.

Oracle REST Data Services (ORDS) : Delete ORDS Metadata
This article describes how to delete ORDS metadata that is no longer needed.

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
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)