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

Latest Articles

Oracle Cloud : APEX Application Development Service (APX) - Create Service
This article provides a run through of creating a new APEX Application Development (APX) service on the Oracle Cloud.

Using Expressions in Initialization Parameters in Oracle Database 21c
Oracle database 21c introduced the ability to use expressions to set initialization parameters. These expressions can reference other parameters and environment variables.

Qualified Expressions Enhancements in Oracle Database 21c
Oracle database 21c makes it even easier to populate collections using qualified expressions.

FOR LOOP Iteration Enhancements in Oracle Database 21c
The FOR LOOP iteration control has been enhanced in Oracle database 21c.

SQL Macros in Oracle Database 21c
SQL Macros improve code reuse by factoring out common expressions and statements into reusable components.

Blockchain Tables in Oracle Database 21c
A blockchain table is a tamper-proof, insert-only table with an associated table-level and row-level retention period.

JSON_TRANSFORM in Oracle Database 21c
The JSON_TRANSFORM function was introduced in Oracle database 21c to simplify the modification of JSON data.

JSON Data Type in Oracle Database 21c
The JSON data type was introduced in the Oracle 20c preview release to provide native JSON support and improve the performance of JSON processing. It has become generally available in Oracle 21c.

 

Convert CentOS 8 to Oracle Linux 8 (OL8)
This article demonstrates how to convert a CentOS 8 installation to Oracle Linux 8 (OL8).

Oracle Database 12c Release 1 (12.1) Installation On Oracle Linux 8 (OL8)
A brief guide to installing Oracle 12c Release 1 (12.1) on Oracle Linux 8 (OL8).

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

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.

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

Oracle Documentation

11gR1, 11gR2
12cR1, 12cR2, 18c, 19c, 20c, 21c
ORDS 3.0, ORDS 17, ORDS 18, ORDS 19, ORDS 20
APEX 20.1, APEX 20.2, APEX Old Releases
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)