8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » 19c » Here


Oracle 19c Articles

Oracle Database 19c : Miscellaneous Articles

Automatic Indexing (DBMS_AUTO_INDEX) in Oracle Database 19c - Oracle database 19c introduced the automatic indexing feature, which lets you hand over some of the decisions about index management to the database.

Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 19c - This article contains an example of setting up a physical standby database for Oracle 19c using the Data Guard Broker.

GeoJSON Data Support in Oracle Database 19c - In this article we demonstrate the support for GeoJSON data in Oracle Database 19c. Specifically the mapping between GeoJSON data and the Oracle Spatial SDO_GEOMETRY object type.

JSON Support Enhancements in Oracle Database 19c - Oracle 19c includes several enhancements to the JSON functionality in the database. This post acts as a links page to separate articles on each feature.

JSON_MERGEPATCH in Oracle Database 19c - The JSON_MERGEPATCH function is used to modify parts of a JSON document in select and update operations.

JSON_OBJECT Enhancements in Oracle Database 19c - The SQL/JSON function JSON_OBJECT got a whole lot easier to use in Oracle 19c.

JSON_SERIALIZE in Oracle Database 19c - The JSON_SERIALIZE function converts a JSON document from any supported data type to text.

LISTAGG DISTINCT in Oracle Database 19c - Oracle 19c includes the ability to remove duplicates from the LISTAGG results by including the DEFAULT keyword.

Mapping of JSON Data To and From SQL Object Types in Oracle Database 19c - Oracle database 19c allows JSON data to instantiate user-defined object type instances, and user defined object-type instances can be converted to JSON data.

Materialized View Support for Queries Containing JSON_TABLE in Oracle Database 19c - Oracle 19c can perform query rewrites of statements using some SQL/JSON functions (JSON_VALUE, JSON_EXISTS) to use a materialized view containing and appropriate JSON_TABLE call.

Multitenant : DBCA PDB Relocate in Oracle Database 19c - In Oracle 19c it's possible to perform a relocate of a pluggable database (PDB) using the Database Configuration Assistant (DBCA).

Multitenant : DBCA PDB Remote Clone in Oracle Database 19c - In Oracle 19c it's possible to perform a remote clone of a pluggable database (PDB) using the Database Configuration Assistant (DBCA).

Multitenant : Upgrading to Oracle Database 19c - This article provides an overview of upgrading an existing multitenant database to Oracle 19c.

SQL NESTED Clause Instead of JSON_TABLE in Oracle Database 19c - The SQL NESTED clause allows us to write the equivalent of the LEFT OUTER JOIN JSON_TABLE using a simplified syntax.

Multitenant : New Features in 19c - A list of the Multitenant new features introduced in Oracle database 19c, with links.

Upgrading to Oracle Database 19c (Non-CDB) - This article provides an overview of upgrading an existing non-CDB database to Oracle 19c.

Oracle Database 19c : Installations

Oracle Database 19c Installation On Oracle Linux 7 (OL7) - This article describes the installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit.

Oracle Database 19c Installation On Oracle Linux 8 (OL8) - This article describes the installation of Oracle Database 19c 64-bit on Oracle Linux 8 (OL8) 64-bit.

Oracle Database 19c RPM Installation On Oracle Linux 7 (OL7) - This article describes the RPM installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit.

Oracle Database 19c Installation On Fedora 29 (F29) - This article describes the installation of Oracle Database 19c 64-bit on Fedora 29 (F29).

Oracle Database 19c Installation On Fedora 30 (F30) - This article describes the installation of Oracle Database 19c 64-bit on Fedora 30 (F30).

Oracle Database 19c RAC On Oracle Linux 7 Using VirtualBox and Vagrant - This article describes the "hands-off" installation of Oracle Database 19c RAC on Oracle Linux 7 using VirtualBox and Vagrant with no additional shared disk devices.

External 19c Links

Documentation: Oracle Database 19c

livesql.oracle.com - LiveSQL is now running on Oracle 19c, so you can start trying it out now.

YouTube : Oracle Learning Channel