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.