Latest Articles
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 18c Installation On Fedora 30 (F30)
This article describes the installation of Oracle Database 18c 64-bit on Fedora 30 (F30).
Fedora 30 (F30) Installation
This article provides a pictorial guide for performing a basic server installation of Fedora 30 (F30).
Create a Vagrant Base Box (VirtualBox)
In this article we demonstrate the creation of a new Vagrant base box using a Fedora distribution and VirtualBox.
Oracle Database 19c RPM Installation On Oracle Linux 7 (OL7)
This article describes the RPM installation of Oracle Database 19c 64-bit on Oracle Linux7 (OL7) 64-bit.
Multitenant : Usable Backups of Non-CDBs and Relocated PDBs in Oracle Database 18c
Oracle 18c allows backups prior to the non-CDB to PDB conversion to be used as preplugin backups by making the backup metadata available to the destination CDB instance.
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 an 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.
Latest Videos
Check out my YouTube channel here.
- Multitenant : PDB Refresh
- Multitenant : PDB Archive Files
- Multitenant : Relocate a Pluggable Database (PDB)
- Multitenant : Hot Clone a Pluggable Database (PDB)
- LISTAGG Analytic Function
- JSON_SERIALIZE Function in 19c
- JSON_MERGEPATCH Function in 19c
- JSON_EQUAL Condition in 18c
Quick Links
- 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.
Oracle Documentation
8iR3,
9iR1,
9iR2
10gR1,
10gR2,
11gR1,
11gR2
12cR1,
12cR2,
18c,
19c
ORDS 3.0,
ORDS 17,
ORDS 18
EM 10g,
EM 11g,
EM 12c,
EM 13c
ADW
AS10g R2,
AS10g R3,
FMW 11gR1,
FMW 12cR1,
FMW 12cR2
Oracle VM,
VirtualBox
Oracle Resources
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