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

Home » Articles » 18c » Here


Oracle 18c Articles

Oracle Database 18c : Miscellaneous Articles

Oracle Database 18c is the equivalent of the 12.2.0.2 patchset, so it is part of the 12.2 release cycle.

Approximate Top-N Query Processing (APPROX_RANK, APPROX_SUM, APPROX_COUNT) In Oracle Database 18c - The APPROX_RANK, APPROX_SUM and APPROX_COUNT functions were introduced in Oracle 18c to allow approximate top-n query processing.

ALTER SYSTEM CANCEL SQL : Cancel a SQL Statement in a Session in Oracle Database 18c - The ability to cancel a SQL statement using the ALTER SYSTEM CANCEL SQL statement was introduced in Oracle Database 18c as an alternative to killing a rogue session.

Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 18c - This article contains an example of setting up a physical standby database for Oracle 18c using the Data Guard Broker.

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

DBMS_SESSION.SLEEP Replaces DBMS_LOCK.SLEEP in Oracle Database 18c - The SLEEP procedure is added to the DBMS_SESSION package and deprecated from the DBMS_LOCK package in Oracle Database 18c.

Encrypt Sensitive Credential Data in the Data Dictionary in Oracle Database 18c - This article gives an overview of encrypting sensitive credential data in the data dictionary. This feature was introduced in Oracle database 18c.

Inline External Tables in Oracle Database 18c - Oracle Database 18c allows you to access data in flat files using an inline external table defined in a SELECT statement.

JSON Data Guide Enhancements in Oracle Database 18c - This article covers the enhancements to the JSON Data Guide functionality in Oracle Database 18c.

JSON_EQUAL Condition in Oracle Database 18c - The JSON_EQUAL condition was introduced in 18c to allow JSON documents to be compared regardless of member order or document formatting.

JSON_TABLE Enhancements in Oracle Database 18c - This article covers the enhancements to the JSON_TABLE function in Oracle Database 18c.

JSON Support Enhancements in Oracle Database 18c - Oracle 18c includes several enhancements to the JSON functionality in the database. This article details some of them, as well as linking to separate articles on others.

Multitenant : New Features in 18c - A list of the Multitenant new features introduced in Oracle database 18c, with links.

Multitenant : CDB Fleet Management in Oracle Database 18c - Oracle 18c allows you to monitor multiple container databases centrally as a fleet.

Multitenant : Copying a PDB in a Data Guard Environment in Oracle Database 18c - The STANDBY_PDB_SOURCE_FILE_DBLINK and STANDBY_PDB_SOURCE_FILE_DIRECTORY initialisation parameters make remote clones and plugin operations much simpler in Oracle 18c.

Multitenant : DBCA PDB Clone and DBCA CDB Duplicate in Oracle Database 18c - In Oracle 18c it's now possible to clone a pluggable database (PDB) and duplicate a container database (CDB) using the Database Configuration Assistant (DBCA).

Multitenant : Duplicate a Pluggable Database (PDB) to an existing Container Database (CDB) in Oracle Database 18c - Oracle 18c allows you to duplicate a pluggable database (PDB) from one container database (CDB) instance to another existing CDB instance using RMAN.

Multitenant : PDB Lockdown Profile Enhancements in Oracle Database 18c - Oracle database 18c extends the PDB Lockdown Profiles functionality introduced in Oracle database 12.2, making it even easier to restrict the operations and functionality available from within a PDB.

Multitenant : PDB Snapshot Carousel in Oracle Database 18c - Oracle 18c introduced the concept of a snapshot carousel, which is a series of point-in-time copies, or snapshots, of a PDB.

Multitenant : Refreshable PDB Switchover in Oracle Database 18c - Oracle 18c allows you to switch the roles of a source PDB and a refreshable PDB.

Multitenant : Upgrading to Oracle Database 18c - This article provides an overview of upgrading an existing multitenant database to Oracle 18c.

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.

Online MERGE PARTITION and MERGE SUBPARTITION in Oracle Database 18c - In Oracle Database 18c the MERGE PARTITION and MERGE SUBPARTITION operations on heap tables can be performed online so they don't block DML.

Oracle SQL and PL/SQL Enhancements in Oracle Database 18c - This page provides links to all the separate articles on SQL and PL/SQL enhancements in Oracle Database 18c.

Polymorphic Table Functions in Oracle Database 18c - The return type of a Polymorphic Table Function (PTF) can be determined by input parameters. This differs from conventional table functions, where the output table type is fixed at compile time.

Private Temporary Tables in Oracle Database 18c - Oracle 18c introduced the concept of a private temporary table, a memory-based temporary table that is dropped at the end of the session or transaction depending on the setup.

Qualified Expressions (Populating Record Types and Associative Arrays) in PL/SQL in Oracle Database 18c - Qualified expressions provide and alternative way to define the value of complex objects, which in some cases can make the code look neater.

Read-Only Oracle Homes in Oracle Database 18c - Oracle 18c introduced the concept of a read-only Oracle home, where all configuration and log files can be kept separate from the Oracle binaries.

Scalable Sequences in Oracle Database 18c - Scalable sequences are designed to reduce problems with hot index blocks during large scale data loads into tables with sequence generated primary keys on single instance and RAC databases.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 18c, 19c and 21c - This post summarises the enhancements to the scheduler in Oracle Database 18c, 19c and 21c.

Schema Only Accounts in Oracle Database 18c - Schema only accounts don't allow direct connections, so administration of their objects is done via a DBA user or a proxy user.

Simple Oracle Document Access (SODA) for PL/SQL in Oracle Database 18c - This article gives an overview of the Simple Oracle Document Access (SODA) for PL/SQL functionality in Oracle Database 18c.

TREAT(... AS JSON) in Oracle Database 18c - In Oracle 18c the TREAT function can be used in SQL to change the declared type of an expression to JSON, where the expression is an object containing JSON data.

TO_UTC_TIMESTAMP_TZ Function in Oracle Database 18c - Oracle 18c introduced the new TO_UTC_TIMESTAMP_TZ function to help deal with ISO 8601 date strings.

Upgrading to Oracle Database 18c (Non-CDB) - This article provides an overview of upgrading an existing non-CDB database to Oracle 18c.

Oracle Database 18c : Installations

Oracle Database 18c Installation On Oracle Linux 6 (OL6) and 7 (OL7) - This article describes the installation of Oracle Database 18c 64-bit on Oracle Linux 6 (OL6) and 7 (OL7) 64-bit.

Oracle Database 18c Installation On Oracle Linux 8 (OL8) - This article describes the installation of Oracle Database 18c 64-bit on Oracle Linux 8 (OL8) 64-bit.

Oracle Database 18c RPM Installation On Oracle Linux 6 (OL6) and 7 (OL7) - This article describes the RPM installation of Oracle Database 18c 64-bit on Oracle Linux 6 (OL6) and 7 (OL7) 64-bit.

Oracle Database 18c Express Edition (XE) RPM Installation On Oracle Linux 6 (OL6) and 7 (OL7) - This article describes the Oracle Database 18c Express Edition (XE) RPM installation on Oracle Linux 6 (OL6) and 7 (OL7) 64-bit.

Oracle Database 18c RAC On Oracle Linux 7 Using VirtualBox and Vagrant - This article describes the "hands-off" installation of Oracle Database 18c RAC on Oracle Linux 7 using VirtualBox and Vagrant with no additional shared disk devices.

Oracle Database 18c Installation On Fedora 28 (F28) - This article describes the installation of Oracle Database 18c 64-bit on Fedora 28 (F28).

Oracle Database 18c Installation On Fedora 29 (F29) - This article describes the installation of Oracle Database 18c 64-bit on Fedora 29 (F29).

Oracle Database 18c Installation On Fedora 30 (F30) - This article describes the installation of Oracle Database 18c 64-bit on Fedora 30 (F30).

Oracle Database 18c Installation On Fedora 31 (F31) - This article describes the installation of Oracle Database 18c 64-bit on Fedora 31 (F31).

Oracle Cloud Infrastructure (OCI) : Create a Database VM - This article shows how to create a database virtual machine under Oracle Cloud Infrastructure (OCI).

Autonomous Database

Oracle Cloud : Autonomous Data Warehouse (ADW) - Create Service - This article provides a run through of creating a new Autonomous Data Warehouse (ADW) service on the Oracle Cloud.

Oracle Cloud : Autonomous Data Warehouse (ADW) - Load Data from an Object Store (DBMS_CLOUD) - This article demonstrates how to load data into the Autonomous Data Warehouse (ADW) service on the Oracle Cloud using the DBMS_CLOUD package.

Oracle Cloud : Autonomous Data Warehouse (ADW) - Import Data from an Object Store (impdp) - This article demonstrates how to import data into the Autonomous Data Warehouse (ADW) service on the Oracle Cloud using the impdp utility.

Oracle Cloud : Autonomous Transaction Processing (ATP) - Create Service - This article provides a run through of creating a new Autonomous Transaction Processing (ATP) service on the Oracle Cloud.

Autonomous Data Warehouse Cloud Hands-On Lab : My Thoughts - My first impressions of the Autonomous Data Warehouse Cloud based on a hands-on lab I attended at Oracle OpenWorld 2017.

Oracle Database 18c is NOT an Autonomous Database! - A discussion about the distinction between Oracle Database 18c and the Autonomous Database.

Oracle Database 18c is NOT an Autonomous Database! (Update) - A continuation of the discussion about the distinction between Oracle Database 18c and the Autonomous Database.

External 18c Links

Documentation: Oracle Database 18c

YouTube : Oracle Learning Channel