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.
Check out my YouTube channel here.
- Long Identifiers in Oracle Database 12.2 Onward
- JSON Data Type in Oracle Database 21c
- Virtual Columns in Oracle Database 11g Onward
- Convert CentOS to Oracle Linux
- Read-Only Partitions and Subpartitions in Oracle 12.2 Onward
- Invisible Indexes in Oracle Database 11g Onward
- Bind Variables : For Performance and Protection Against SQL Injection
- SQL for Beginners
- Multitenant Articles
- ORDS Articles
- JSON Articles
- Docker/Container 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.
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
FMW 11gR1, FMW 12cR1, FMW 12cR2
Oracle VM, VirtualBox
Oracle Developer Community,
VirtualBox Developer VMs,
Release Schedule of Current Database Releases (Doc ID 742060.1)