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

Latest Articles

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.

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.

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.

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

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.

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.

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.

 

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.

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.

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.

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.

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.

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.

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.

Oracle HTTP Server (OHS) 11g and 12c : Configure SSL
This article describes how to configure SSL for Oracle HTTP Server (OHS) 11g and 12c.

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

8i R3  9i R1  9i R2 
10g R1  10g R2   
11g R1  11g R2   
12c R1  12c R2  18c 

Oracle Documentation

8iR3, 9iR1, 9iR2
10gR1, 10gR2, 11gR1, 11gR2
12cR1, 12cR2, 18c
ORDS 3.0, ORDS 17, ORDS 18
EM 10g, EM 11g, EM 12c, EM 13c
AS10g R2, AS10g R3,
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