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

Latest Articles

Oracle Cloud Infrastructure (OCI) : Create a Bastion
This article shows how to create a bastion under Oracle Cloud Infrastructure (OCI).

DBMS_XPLAN : Compare Execution Plans in Oracle Database 19c and 21c (COMPARE_PLANS, COMPARE_CURSORS and COMPARE_EXPLAIN)
This article demonstrates how to compare execution plans using the DBMS_XPLAN package in Oracle Database 19c and 21c.

Auditing Enhancements in Oracle Database 21c
This article gives an overview of the auditing enhancements in Oracle database 21c.

Multitenant : Common Mandatory Profiles in the CDB Root in Oracle Database 21c
This article demonstrates using a common mandatory profile to enforce password complexity in all PDBs without affecting existing user-level profiles.

Data Pump (expdp, impdp) Enhancements in Oracle Database 19c
This article gives an overview of the Data Pump enhancements in Oracle Database 19c.

Exclude ENCRYPTION Clause on Import in Oracle Database 19c
This article demonstrates how to use the OMIT_ENCRYPTION_CLAUSE of the import TRANSFORM parameter in Oracle database 19c.

BIT_AND_AGG, BIT_OR_AGG and BIT_XOR_AGG Analytic Functions
This article gives an overview of the BIT_AND_AGG, BIT_OR_AGG and BIT_XOR_AGG analytic functions, introduced in Oracle database 21c.

ANY_VALUE Aggregate Function in Oracle Database 21c
The ANY_VALUE function allows us to safely drop columns out of a GROUP BY clause to reduce any performance overhead.

 

SQL Set Operator Enhancements (EXCEPT, EXCEPT ALL, MINUS ALL, INTERSECT ALL) in Oracle Database 21c
Oracle 21c includes a number of enhancements to SQL set operators including EXCEPT, EXCEPT ALL, MINUS ALL and INTERSECT ALL.

KURTOSIS_POP and KURTOSIS_SAMP Analytic Functions
The KURTOSIS_POP and KURTOSIS_SAMP analytic functions were added in Oracle 21c to describe the 'tailedness' or shape of a probability distribution.

SKEWNESS_POP and SKEWNESS_SAMP Analytic Functions
The SKEWNESS_POP and SKEWNESS_SAMP analytic functions were added in Oracle 21c to measure asymmetry, or skew, in the distribution of data.

Analytic Function Syntax Enhancements (WINDOW, GROUPS, EXCLUDE) in Oracle Database 21c
This article describes the syntax enhancements to analytic function introduced in Oracle database 21c.

CHECKSUM Analytic Function
This article gives an overview of the CHECKSUM analytic function introduced in Oracle database 21c.

Fedora 35 (F35) Installation
This article provides a pictorial guide for performing a basic server installation of Fedora 35 (F35).

Oracle Database 21c Installation On Fedora 34 (F34)
This article describes the installation of Oracle Database 21c 64-bit on Fedora 34 (F34).

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

Latest Videos

Check out my YouTube channel here.

Quick Links

You can follow me on these networks:

You can get an oracle-base.com t-shirt here.

Search Docs

11g R1  11g R2     
12c R1  12c R2     
18c  19c  21c   

Oracle Documentation

11gR1, 11gR2
12cR1, 12cR2, 18c, 19c, 21c
ORDS 3.0, ORDS 17, ORDS 18, ORDS 19, ORDS 20, ORDS 21
APEX 20.1, APEX 20.2, APEX 21.1, APEX Old Releases
EM 10g, EM 11g, EM 12c, EM 13c
ADW, ATP
Middleware, 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,
Release Schedule of Current Database Releases (Doc ID 742060.1)