Latest Articles
Silent Upgrade of Oracle Enterprise Manager Cloud Control to 13c Release 3 (13cR3)
This article describes a silent upgrade of Enterprise Manager Cloud Control to 13c Release 3 (13cR3).
Oracle Application Express (APEX) Production Environment Topology
This article gives an example of the topology necessary to deploy an APEX application safely in a production environment.
Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0) Silent Installation on Oracle Linux 7
This article describes the silent installation of Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0) on Oracle Linux 7.
Dbvisit Standby 9 Installation on Oracle Linux 7
This article describes the installation and usage of Dbvisit Standby 9 on Oracle Linux 7 with Oracle Database 19c.
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.
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.
Latest Videos
Check out my YouTube channel here.
- CORR Analytic Function
- AVG, MEDIAN, MIN and MAX Analytic Functions
- FIRST_VALUE and LAST_VALUE Analytic Functions
- LAG and LEAD Analytic Functions
- RANK, DENSE_RANK, ROW_NUMBER Analytic Functions
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,
ORDS 19
EM 10g,
EM 11g,
EM 12c,
EM 13c
ADW,
ATP
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