8i | 9i | 10g | 11g | 12c | 13c | 18c | 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.

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.

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.

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.

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 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.

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.

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.

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 Fedora 28 (F28) - This article describes the installation of Oracle Database 18c 64-bit on Fedora 28 (F28).

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 Cloud : Database as a Service (DBaaS) - Create Service - This article provides a run through of creating a new DBaaS service on the Oracle Cloud.

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