Latest Articles

Enhanced Partitioning Metadata in Oracle Database 23c
Oracle database 23c makes it easier to display the high value of partitions using two new columns in the ALL_TAB_PARTITIONS view.

Hybrid Partitioned Table Enhancements in Oracle Database 23c
This article demonstrates hybrid partitioned tables with interval and auto-list partitioning in Oracle Database 23c.

Materialized View Enhancements in Oracle Database 23c
This post introduces some of the materialized view enhancements in Oracle database 23c.

Logical Partition Change Tracking (LPCT) for Materialized Views in Oracle Database 23c
In Oracle database 23c Logical Partition Change Tracking (LPCT) allows materialized view staleness to be tracked at the level of a logical partition.

Materialized View Concurrent Refreshes in Oracle Database 23c
In Oracle 23c materialized view refreshes can be performed concurrently for on-commit fast refreshes by adding the ENABLE CONCURRENT REFRESH clause.

Materialized View Support for ANSI Joins in Oracle Database 23c
In Oracle 23c materialized views support query rewrites for SQL statements using ANSI or Oracle style joins.

DBMS_HCHECK in Oracle Database 23c
In Oracle 23c the DBMS_HCHECK package allows us to check for known data dictionary problems in the database.

Immutable Table Enhancements in Oracle Database 23c
Immutable tables were introduced to Oracle 21.3 and 19.11 at the same time, so it could be considered a 19c and 21c new feature. This article demonstrates the enhancements to immutable tables in Oracle 23c.

 

Blockchain Table Enhancements in Oracle Database 23c
Blockchain tables were first introduced in Oracle 21c, and backported to Oracle 19c. This article demonstrates the enhancements to blockchain tables in Oracle 23c.

SQL Firewall in Oracle Database 23c
The SQL Firewall allows us to detect, block and log unexpected SQL and session contexts in an Oracle 23c database, giving us greater control to prevent unusual activity.

Multilingual Engine (MLE) for JavaScript in Oracle Database 23c
Oracle 23c extends the multilingual engine (MLE) with the addition of persistent MLE modules and call specs that allow modules to be called from SQL and PL/SQL.

Hybrid Read-Only Mode for PDBs in Oracle Database 23c
Oracle 23c allows us to open PDBs in hybrid read-only mode. This allows common users to work in read-write mode, while local users and common application users are restricted to read-only mode.

Read-Only PDB Users in Oracle Database 23c
Oracle database 23c allows us to make PDB users read-only, which makes a connected session act like the database is opened in read-only mode, preventing the session from performing write operations.

Database Callouts : Simplifying Certificate Management and TLS Version Support by Using a Reverse Proxy
This article describes how using a reverse proxy can simplify the certificate management required for database callouts. It also explains how this can be used to overcome TLS support issues encountered by older systems.

ARGUMENT Command in SQL*Plus 23c and SQLcl 22.4
The ARGUMENT command in SQL*Plus 23c and SQLcl 22.4 allows us to manage arguments passed to a script. This includes the prompt or default value if an argument is missing, and whether the user input from a prompt should he echoed to the screen.

Auditing Enhancements in Oracle Database 23c
This post describes some of the auditing enhancements in Oracle database 23c.

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)
• Ansible Playbooks : Vault
• Ansible Playbooks : Roles
• Ansible Playbooks : Users and Groups
• Ansible Playbooks : Tags

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)
• Mastodon (@oraclebase@techhub.social)
• Bluesky (@oraclebase.bsky.social)
• Facebook
• LinkedIn
• YouTube
• GitHub
• Linktree

Oracle Documentation

12cR1, 12cR2, 18c, 19c, 21c, 23c
ORDS 19, ORDS 20, ORDS 21, ORDS 22, ORDS 23
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)