Category: Oracle

This article demonstrates the use of the Oracle database API for MongoDB functionality built into Oracle REST Data Services (ORDS).

Oracle database 23ai introduced JSON collections, which are specifically for use with the Oracle Database API for MongoDB and Simple Oracle Document Access (SODA).

This article demonstrates the GraphQL functionality built into Oracle REST Data Services (ORDS) from version 23.3 onward.

This article describes the GraphQL functionality introduced in Oracle Database 23ai.

This article provides a simple example of using the AI Vector Search feature in Oracle database 23ai.

Bigfile tablespaces were introduced in Oracle 10g. In Oracle database 23ai bigfile tablespaces are the default.

From Oracle database 23ai onward we can use the DBMS_SPACE package to shrink a bigfile tablespace to reclaim unused space.

By default many JSON functions return null if they encounter a runtime error. Oracle database 23ai introduced the JSON_BEHAVIOR parameter to allow us to alter this default behaviour for our session.

Oracle database 23ai has introduced the ability to convert nulls to empty strings during JSON generation.

This article describes the installation of Oracle Database 21c 64-bit on Fedora 40 (F40).