Oracle DBA and development articles, scripts, HOWTOs and forums (8i, 9i, 10g, 11g, 12c, 13c, 18c, 19c, 21c, 23c)

Latest Articles

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.

JSON_TRANSFORM Enhancements in Oracle Database 23c
In Oracle 23c the JSON_TRANSFORM function has lots of new operations, conditional control and richer path support.

Aggregation over INTERVAL Datatypes in Oracle Database 23c
Oracle 23c allows us to use the SUM and AVG aggregate and analytic functions with INTERVAL datatypes for the first time.

Oracle REST Data Services (ORDS) : AutoREST of JSON-Relational Duality Views
This article gives an overview of the AutoREST functionality of Oracle REST Data Services (ORDS) against JSON-relational duality views in Oracle 23c.

Automatic PL/SQL to SQL Transpiler in Oracle Database 23c
The automatic SQL transpiler in Oracle 23c allows some functions to be converted into SQL expressions to reduce the overhead of function calls in SQL.

CASE Statement and CASE Expression Enhancements in Oracle Database 23c
In Oracle database 23c the simple CASE statement and expression are more flexible, allowing dangling predicates and multiple choices in a single WHEN clause.

DEFAULT ON NULL FOR INSERT AND UPDATE in Oracle Database 23c
In Oracle 23c we can define a column as DEFAULT ON NULL FOR INSERT AND UPDATE. This replaces explicit null values with the default value in update statements.

DML RETURNING Clause Enhancements in Oracle Database 23c
This article demonstrates the enhancements to the DML RETURNING clause introduced in Oracle database 23c.

Check out my YouTube channel here.

You can follow me on these networks:

Search Docs