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.
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.
LISTAGG DISTINCT in Oracle Database 19c
Oracle 19c includes the ability to remove duplicates from the LISTAGG results by including the DEFAULT keyword.
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.
Run Oracle Forms 11g on Windows using OpenJDK 8 and IcedTea
This article shows how to run Oracle Forms 11g using OpenJDK 8 and IcedTea as a replacement for Java Web Start. It's not a supported solution, but it works.
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.
JSON_SERIALIZE in Oracle Database 19c
The JSON_SERIALIZE function converts a JSON document from any supported data type to text.
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.
Upgrading to Oracle Database 19c (Non-CDB)
This article provides an overview of upgrading an existing non-CDB database to Oracle 19c.
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.
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.
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 Oracle Linux 7 (OL7)
This article describes the installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit.
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.
Check out my YouTube channel here.
- Private Temporary Tables
- Converting Exact to Approximate Query Processing
- JSON_OBJECT Enhancements in 19c
- SQL/JSON : Generate JSON from SQL
- Override External Table Parameters and Inline External Tables
- Real-Time Materialized Views
- Collation and Case-Insensitive Queries
- Extended Data Types
- JSON Data Guide
- SQL for Beginners
- Multitenant Articles
- ORDS Articles
- JSON Articles
- Docker Articles
- Writing Tips
- Public Speaking Tips
- Learning New Things
- What Employers Want
- Why Automation Matters
You can follow me on these networks:
You can get an oracle-base.com t-shirt here.
10gR1, 10gR2, 11gR1, 11gR2
12cR1, 12cR2, 18c, 19c
ORDS 3.0, ORDS 17, ORDS 18
EM 10g, EM 11g, EM 12c, EM 13c
AS10g R2, AS10g R3,
FMW 11gR1, FMW 12cR1, FMW 12cR2
Oracle VM, VirtualBox
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