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

Latest Articles

Oracle REST Data Services (ORDS) : Database API - Data Pump
The Oracle REST Data Services (ORDS) database API allows us to create Data Pump export and import jobs via REST web service calls.

Data Pump API for PL/SQL (DBMS_DATAPUMP)
The DBMS_DATAPUMP package provides a PL/SQL API, allowing us to define Data Pump operations programmatically. This article provides a few examples to get you started.

Oracle REST Data Services (ORDS) : Database API - Setup
The Oracle REST Data Services (ORDS) database API allows us to perform some database administration via REST web service calls. This article covers the basic setup.

Oracle REST Data Services (ORDS) : Database API - PDB Lifecyle Management
The Oracle REST Data Services (ORDS) database API allows us to manage the lifecycle of PDBs via REST web service calls.

Multitenant : Dynamic CPU Scaling - Resource Manager Control of CPU using CPU_COUNT and CPU_MIN_COUNT
Resource Manager can control CPU usage in PDBs using the CPU_COUNT and CPU_MIN_COUNT parameters. Oracle call this Dynamic CPU Scaling.

Oracle Cloud : Autonomous JSON Database (AJD) - Create Service
This article provides a run through of creating a new Autonomous JSON Database (AJD) service on the Oracle Cloud.

SQLcl : Simple Oracle Document Access (SODA) for SQLcl
This article gives an overview of the integration of Simple Oracle Document Access (SODA) in SQLcl.

Real-Time Statistics in Oracle Database 19c
Oracle database 19c introduced real-time statistics to reduce the chances that stale statistics will adversely affect optimizer decisions when generating execution plans.

 

Liquibase and Source Control : Changes to Scripts Over Time
A discussion of how to manage changes to scripts over time with Liquibase.

SQL Quarantine in Oracle Database 19c
Oracle Database 19c introduced an extension of Runaway Query Management called SQL Quarantine.

Oracle Databases and CI/CD Pipelines
This article contains a general discussion about how Oracle Databases can fit into CI/CD pipelines.

SQLcl : Deploying Oracle Application Express (APEX) Applications using the SQLcl implementation of Liquibase
This article demonstrates how to deploy Oracle Application Express (APEX) applications using the SQLcl implementation of Liquibase.

Hybrid Partitioned Tables in Oracle Database 19c
This article shows how to combine internal and external partitions into a single Hybrid Partitioned Table in Oracle Database 19c.

Liquibase : Deploying Oracle Application Express (APEX) Applications
This article demonstrates how to deploy Oracle Application Express (APEX) applications using Liquibase.

APEX_DATA_PARSER : Convert simple CSV, JSON, XML and XLSX data to rows and columns.
The APEX_DATA_PARSER package allows you to easily convert simple CSV, JSON, XML and XLSX data into rows and columns from SQL.

Podman : Generate and Play Kubernetes YAML Files
Podman can generate Kubernetes YAML files from existing pod definitions, and use the generated YAML files to fire up new pods.

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 
20c       

Oracle Documentation

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