8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Latest Articles
Loading JSON Data using External Tables in Oracle Database 23c
In Oracle database 23c loading JSON data using external tables got much simpler.
Oracle Database 21c Installation On Fedora 39 (F39)
This article describes the installation of Oracle Database 21c 64-bit on Fedora 39 (F39).
Oracle Database 19c Installation On Fedora 39 (F39)
This article describes the installation of Oracle Database 19c 64-bit on Fedora 39 (F39).
Fedora 39 (F39) Installation
This article provides a pictorial guide for performing a basic server installation of Fedora 39 (F39).
Oracle Database 19c RAC On Oracle Linux 9 Using VirtualBox and Vagrant
This article describes the hands-off installation of Oracle Database 19c RAC on Oracle Linux 9 using VirtualBox and Vagrant with no additional shared disk devices.
Oracle Database 19c Installation On Oracle Linux 9 (OL9)
This article describes the installation of Oracle Database 19c 64-bit on Oracle Linux 9 (OL9) 64-bit.
Transport Layer Security (TLS) Connections without a Client Wallet in Oracle Database 23c
In previous releases making HTTPS callouts from the database required the use of a client wallet. From Oracle database 23c onward we can use the operating system certificate store instead.
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.
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)
- YouTube
- GitHub
- Mastodon (@oraclebase@techhub.social)
- Bluesky (@oraclebase.bsky.social)
- Threads
- 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)