8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Latest Articles
Rename LOB Segments in Oracle Database 23c
The article demonstrates how to rename a LOB segment in Oracle 23c.
Oracle REST Data Services (ORDS) : Basic and Digest Authentication on Tomcat using DataSourceRealm
This article demonstrates the use of the Tomcat DataSourceRealm to control authentication to Oracle REST Data Services (ORDS) web services.
Database Resident Connection Pool (DRCP) Enhancements in Oracle Database 23c
Oracle database 23c enhanced the Database Resident Connection Pool (DRCP) functionality to include multiple named pools and implicit connection pooling.
FUZZY_MATCH and PHONIC_ENCODE Data Quality Operators in Oracle Database 23c
Oracle database 23c introduced the FUZZY_MATCH and PHONIC_ENCODE data quality operators to perform fuzzy string matching.
Podman : Install Podman on Oracle Linux 9 (OL9)
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 9 (OL9).
Lock-Free Reservations to Prevent Blocking Sessions in Oracle Database 23c
In Oracle 23c we can use Lock-Free Reservations to reduce the incidents of blocking sessions for frequently updated numeric column values.
SQL Property Graphs and SQL/PGQ in Oracle Database 23c
Oracle have had a Graph Server and Client product for some time, but in Oracle database 23c some of the property graph functionality has been built directly into the database.
CEIL and FLOOR Support DATE, TIMESTAMP, and INTERVAL Data Types in Oracle Database 23c
In Oracle database 23c the CEIL and FLOOR functions support the DATE, TIMESTAMP and INTERVAL data types.
Loading SODA Collections with SQL*Loader in Oracle Database 23c
In Oracle 23c we can use SQL*Loader to load JSON data into a Simple Oracle Document Access (SODA) collection.
Precheck Constraints using JSON Schema in Oracle Database 23c
In Oracle database 23c we can use the PRECHECK keyword to mark check constraints as being validated externally by an application.
XML, JSON and Oracle Text Search Index Enhancements in Oracle Database 23c
In Oracle 23c the CREATE SEARCH INDEX statement allows us to create search indexes on XML, JSON and text data, making the syntax consistent between them.
Predicates for JSON_QUERY and JSON_VALUE in Oracle Database 23c
In Oracle database 23c the JSON_QUERY and JSON_VALUE functions can include multiple predicates in a single JSON path expression, and use the PASSING clause to support variables.
Oracle Database 21c Installation On Fedora 38 (F38)
This article describes the installation of Oracle Database 21c 64-bit on Fedora 38 (F38).
Oracle Database 19c Installation On Fedora 38 (F38)
This article describes the installation of Oracle Database 19c 64-bit on Fedora 38 (F38).
Fedora 38 (F38) Installation
This article provides a pictorial guide for performing a basic server installation of Fedora 38 (F38).
JSON Schema in Oracle 23c
In Oracle 23c a JSON Schema can validate the structure and contents of JSON documents in your database.
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:
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,
Release Schedule of Current Database Releases (Doc ID 742060.1)